Related:

- 1st, 2nd, 3rd position formula in excel
- How to calculate position in excel - Best answers
- How to calculate positions(1st,2nd,3rd...) in Excel ✓ - Forum - Office Software
- Formulas for 1st and 2nd position in class - Forum - Office Software
- Formula in excel for a date ✓ - Forum - Excel
- Student position formula - Forum - Excel
- Formula/Solution - Forum - Excel

## 2 replies

Blocked Profile

to select a data toolbar you can see a sort button,, click it ,, that ask u for assending order or decending order... you select yourself what you want... the decending order will display the oder on decending...

Report

stan

thanks for helping

Report

Ashraf

Thanks

aquarelle

- Posts
- 7098
- Registration date
- Saturday April 7, 2007
- Status
- Moderator
- Last seen
- June 10, 2021

Hi,

Well, I supposed that your data were something like that :

To have the student result position in the column C, try with this formula :

Best regards

"Pour trouver une solution à ses problèmes, il faut s'en donner la peine."

Well, I supposed that your data were something like that :

A B C 1 Students Marks Position 2 Philippe 15 2 3 Sam 19 1 4 Jeny 12 3 5 John 9 4 6 Jane 8 5

To have the student result position in the column C, try with this formula :

**C2=RANK(B2,$B$2:$B$6)**and drop down the formula on C column.Best regards

"Pour trouver une solution à ses problèmes, il faut s'en donner la peine."