Excel Rank Function without duplicate Rank | Microsoft Excel
In this video I will Showing you how to find rank .
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
#Rank_Function
#Duplicate_Rank
#Excel
You can Join With me in facebook-
www.facebook.com/techsolveratiq
My Own Profile-
www.facebook.com/drpsatiq
Excel Video Playlist-
• Microsoft Excel
Word Video Playlist-
• Microsoft Word
Access Video Playlist-
• Microsoft Access
Zoom Tutorial Video Playlist-
• ZOOM Apps
Camtasia Tutorial Video Playlist-
• Video Editing
Here You can find Technical Support in any problem, MS Office, MS Word, Excel, Access. Facebook, Youtube, Muktapath, Teachers.gov.bd, Shikkhokh batoyon etc.
