How to rank the last top ten students
Solved/Closed
James07392
Posts
2
Registration date
Thursday September 9, 2021
Status
Member
Last seen
September 9, 2021
-
Sep 9, 2021 at 07:10 AM
James07392 Posts 2 Registration date Thursday September 9, 2021 Status Member Last seen September 9, 2021 - Sep 9, 2021 at 11:24 AM
James07392 Posts 2 Registration date Thursday September 9, 2021 Status Member Last seen September 9, 2021 - Sep 9, 2021 at 11:24 AM
Related:
- How to rank the last top ten students
- How to rank positions in excel ✓ - Office Software Forum
- Microsoft access free download for students - Download - Databases
- Pycharm download free for students - Download - Development environment
- How to calculate position (1st,2nd,3rd) in excel....? - Excel Forum
- Calculation of positions in excel ✓ - Excel Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
Updated on Sep 9, 2021 at 11:20 AM
Updated on Sep 9, 2021 at 11:20 AM
Hi James,
Can't you sort the result? The sort option can be found on the data ribbon.
A formula to determine rank would look like this:
=RANK(A2,$A$2:$A$127,1)
Where the result are in column A.
A2 refers to the cell with result to determine the rank.
$A$2:$A$127 refers to the range of cells containg all results. The dollar symbols are there to keep the range fixed, when you drag the formula down.
The 1 at the end reverses the rank order, so that the last 10 students will be ranked 1-10.
If you envision a certain result (maybe placing the 10 names in a certain spot), then it is helpful to show how your data looks now and how you want the result to look like. You can do this by providing screenshots, or uploading your file using a free filesharing site and posting back the download link. Always be careful with sensitive data. Dummy data will suffice.
Best regards,
Trowa
Can't you sort the result? The sort option can be found on the data ribbon.
A formula to determine rank would look like this:
=RANK(A2,$A$2:$A$127,1)
Where the result are in column A.
A2 refers to the cell with result to determine the rank.
$A$2:$A$127 refers to the range of cells containg all results. The dollar symbols are there to keep the range fixed, when you drag the formula down.
The 1 at the end reverses the rank order, so that the last 10 students will be ranked 1-10.
If you envision a certain result (maybe placing the 10 names in a certain spot), then it is helpful to show how your data looks now and how you want the result to look like. You can do this by providing screenshots, or uploading your file using a free filesharing site and posting back the download link. Always be careful with sensitive data. Dummy data will suffice.
Best regards,
Trowa
Sep 9, 2021 at 11:24 AM