MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sorting Exam Results


Posted by john farrell on November 16, 2001 5:39 AM

I have a spreadsheet of exam results that also need to show the exam position in the next column [including an equal position, where appropriate e.g. 10=]

The number of candidates in each exam varies.
Can some kind person tell me if this can be done automatically as the results are entered?


Posted by Mark W. on November 16, 2001 6:15 AM

What do you mean by "position"? Are "results" numeric? (nt)

Posted by Dan on November 16, 2001 6:19 AM

Exam position? Do you mean you are trying to rank scores? If so you can use the RANK command:

If your scores are in column A,
put in B1:

=Rank(A1,A:A)

Then copy this formula down in all cells in column B. I'm not sure what you mean by "10=". Please explain that point.

HTH