How To Use Rank OR Position Formula In MS Excel | How To Find Position OR Rank In MS Excel

preview_player
Показать описание
How To Use Rank OR Position Formula In MS Excel | How To Find Position OR Rank In MS Excel 2007, 2010, 2013, 2016, 2019, 365
this video shows how to find position of students in Microsoft Excel using rank formula.
Рекомендации по теме
Комментарии
Автор

very helpful bro and i subscribed your channel too.THANKSSS.

WolfOfficialMemeber
Автор

Aghar 1st position double aye to per 2nd position show nae karta darek 3rd position per show karta ha

opabdulgamer
Автор

Hello sir
I am Atif from Pakistan.
I have asked the question many Excel Experts but none could reply.

For example date is as following

1 Ali obtained 456
2 ajmal obtained 234
3ahmed obtained 235
4 wasim obtained 456.
Now the obtained marks of Ali and wasim are same. If we apply rank formula we get positions as

Ali. 1st
Wasim. 1st
Ahmed. 3rd
Ajmal. 4th.

2nd is missing.

atifmehmood
Автор

this formula did not apply on the following data. 250, 260, 281, 281, 0, 200 in this example this formula does not read duplicate value. duplicate value should be assigned same position but it does not work properly.

kysgvsg
Автор

Remarks is fail but rank is 10 pls check it and rectify it

suseela