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

abdulwajid - Nov 19, 2021 at 02:17 PM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Nov 22, 2021 at 11:11 AM
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

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Nov 22, 2021 at 11:11 AM
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
0