Excel Rank Function with different ranks for same values

Опубликовано: 04 Октябрь 2024
на канале: Excel Rush

168,827

1.3k

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...
---------------------------------------------

Click this link to learn how to manage your personal finance using Excel - • Personal Finance

SUBSCRIBE NOW!
/ @excelrush

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.