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

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.

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

Why do we put the dollar sign

I love your teachings

nice bro thnx

Wow nice work

Thank you

Thanks for this video

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

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.

Thank you

Thhnkww

Thank you

Very good. Continue the good workd