How to calculate position (1st,2nd,3rd) in excel....?

Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
Hello,

Hello,
hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the 1st 2nd 3rd...so on position of student leads from highest to lower one...

regards
hardy

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Hardy,

Use the following formula to determine rank:
=RANK(A2,$A$2:$A$6)

A2 is the cell you want to return the rank for.
$A$2:$A$6 is the range of cells where the student marks are located.
The dollar symbols are there to keep the range fixed, so you can drag the formula down.

Best regards,
Trowa