Hello, I have an issue with ranking, when I use this function and there are two values (for example two students got the same grade) the ranking function ties them but it skips one rank for the next value, like this: Student | Grade | Ranking Monica: 96 1 Chandler: 94 2 Ross: 94 2 Phoebe: 93 4 Rachel: 92 5 Joey: 50 6 As you can see it ranked the ti in second place, but the next value it went straight to fourth place and it doesn't show third place. Is there a way to fix this?
Hi Farid! I hope you were able to figure this out! Sorry I did not see the comment. If you are trying to filter the Rank without filtering the "Grade" column, you will be changing the order of the formulas without updating the location of where the data is coming from - I believe this is why you are getting an error. I would make the "Grade" column part of the filter.
@@SayStephanie hello Stephanie, thank you so much for your respone can you take a look my 1 minute video about that problem ? www.loom.com/share/f0b57db59c4a4e7283003c51ae03e428 still error :(
Simple and to-the-point, love it! Thanks!
Thank you so much, Miss Stephanie! This was the easiest way I learned... God Bless you!
Just done ranking m pupils for 3rd quarter.
Very well explained and in 2 minutes. Great video! Thanks
Excellent! So clear and easy to understand. You saved me!
Thank you this was really helpful for a points system I was doing.
You just saved my life: thanks for this! I own you one!
thanks that helped alot . great thing i found ur channel.
Right to the point! Love it. thanks
super useful! thank you :)
Thanks Steph was very usefull
thanksso much for your advice. We can auto sort without click on the filter triangle (menufilter) ? 10xxxxxxxx
Thanks
thank you. BIG HELP!
Thank you so much.
HOW CAN YOU ADD AN ARROW UP WHEN A STUDENT IMPROVED ITS RANKING AND AN ARROW DOWN WHEN ITS RANKING DECREASE ?
Thank you
How would I go about naming the ranks 1st, 2nd, 3rd etc
Thanks, help me a lot :)
So, I'm watching this 2 Years later, but how do I get the Grade part? Because for the Rank it says I have no input data.
Hello, I have an issue with ranking, when I use this function and there are two values (for example two students got the same grade) the ranking function ties them but it skips one rank for the next value, like this:
Student | Grade | Ranking
Monica: 96 1
Chandler: 94 2
Ross: 94 2
Phoebe: 93 4
Rachel: 92 5
Joey: 50 6
As you can see it ranked the ti in second place, but the next value it went straight to fourth place and it doesn't show third place.
Is there a way to fix this?
=RANK.EQ(B1,$B$1:$B$6)+countif($B$1:B1,B1)-1
Student Grade Ranking
Monica 96 1
Chandler 94 2
Ross 94 3
Phoebe 93 4
Rachel 92 5
Joey 50 6
Hope that helps.
Thanks a lot
GREAT
How do I get names to move and positions to be fixed?
Thankyou so much
what can i do if i need to sort the rank for two/more row?
hello thanks you the help, but i got an error because my "Grade" coluum i grab from another coluum, outside the filter, how can to solve it? thanks
Hi Farid! I hope you were able to figure this out! Sorry I did not see the comment. If you are trying to filter the Rank without filtering the "Grade" column, you will be changing the order of the formulas without updating the location of where the data is coming from - I believe this is why you are getting an error. I would make the "Grade" column part of the filter.
@@SayStephanie hello Stephanie, thank you so much for your respone
can you take a look my 1 minute video about that problem ?
www.loom.com/share/f0b57db59c4a4e7283003c51ae03e428
still error :(
what if they have the same grade?
how if there is 2 same number ?