Auto Numbering Test Scores and want ties to count the same

S

Scott

I have a series of 300 test scores from students and want them automatically
numbered from 1-300 based on best to worst. The problem is I want identical
scores to number the same.
i.e. say after number 10 the next three have identical scores I want all
of those to number 11 and then the following score to be numbered 14.
 
S

Sheeloo

Sort the scores in descending order (assuming they are in Col E)
Enter 1 agains the highest score (assuming you want the rank in Col F)
Enter =IF(E2=E1,F1,F1+1) in the cell below that and copy till end
 
T

T. Valko

Use the RANK function.

55
55
49
22
18

=RANK(A1,A$1:A$5)

Copied down

Returns 1;1;3;4;5
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top