Excel Rank Function with different ranks for same values
162.9 هزار بار بازدید -
8 سال پیش
-
This video will help you
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.
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.
8 سال پیش
در تاریخ 1394/12/14 منتشر شده
است.
162,975
بـار بازدید شده