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 January 16, 2023 - Nov 22, 2021 at 11:11 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Nov 22, 2021 at 11:11 AM
Related:
- 1st, 2nd, 3rd position formula in excel
- How to find position in excel - 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
- Excel date format dd.mm.yyyy - Guide
- Number to words in excel formula - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
547
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