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

Closed
abdulwajid - Nov 19, 2021 at 02:17 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 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
Related:

## 1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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