Rank Function in Excel (+ Powerful Tip for Ranking with IF Criteria)
The Rank Function is straightforward but in this video, I will tell you why you should use RANK.EQ over RANK. I will also show you how to rank if you have an IF criteria (No no, you can't use the RANK function).
I am sure you use RANK function before. But do you know there is also a RANK.EQ function? You might not know of it because you have been using RANK. You can use RANK for now but be wary that Microsoft might remove it in future. That's when you need to use RANK.EQ.
00:00 How to use RANK function
02:21 Using RANK.EQ (same as RANK)
02:46 Using RANK.AVG (affects duplicated ranking)
03:37 Ranking with IF criteria
05:36 Using COUNTIFS to rank with IF criteria (English players)
09:51 Using COUNTIFS to rank with IF criteria (non-English players)
Have you used COUNTIFS for ranking before? Comment below!
Be sure to stay till the end of the video!
If you like more of such Excel tutorials, please subscribe!