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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022  Nov 22, 2021 at 11:11 AM
Related:
 1st, 2nd, 3rd position formula in excel
 1st, 2nd, 3rd position formula in excel pdf  Best answers
 Position formula in excel  Best answers
 How to calculate positions (1st,2nd,3rd...) in Excel ✓  Office Software Forum
 Formulas for 1st and 2nd position in class  Office Software Forum
 Calculation of positions in excel ✓  Excel Forum
 Student position formula  Excel Forum
 Date formula in excel dd/mm/yyyy  Guide
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
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
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