Excel Rank Function with different ranks for same values

This video will help you get Ranks in Excel, without repetative Ranks

The normal =Rank function in Excel gives you the same rank for 2 or more same values.
For example, if there are 4 values - 34, 30, 38, 34; ranking is done in descending order,
38 will get rank 1
34 will get rank 2
34 will get rank 2
30 will get rank 4

This can be avoided using =Rank with =Countif function.
Thus, 2 same values will get different ranks, one after the other.

So the new ranking will be,
38 will get rank 1
34 will get rank 2
34 will get rank 3
30 will get rank 4

---------------------

After this video, learn in-depth about Pivot tables and charts, Enroll for an Online course conducted by me on Master Business Reporting with Pivot tables and charts in Excel

Also, as you are a special Viewer/ Subscriber,
we would like to give out a special discount just for you,
so click here -
https://www.udemy.com/master-business-reporting/?couponCode=EXCELRUSHYOUTUBE
---------------------------------------------

Click this link to learn how to manage your personal finance using Excel - https://www.youtube.com/playlist?list=PLsHesq9dVLnKFoNtLSrLbrPXPL_xZc6AG

SUBSCRIBE NOW!
https://www.youtube.com/channel/UC8S-Az-vTSItYE-XR9Fb1Zg?sub_confirmation=1

Blog
Visit www.ExcelRush.com for my free blog to learn Excel in-depth.

Rushabh Shah is an expert in training Professionals & Students in Excel's Advanced features & formulas. These tutorials are simply a way to spread the knowledge and make people more productive using Excel.