Auto Numbering Test Scores and want ties to count the same
Use the RANK function.
55
55
49
22
18
=RANK(A1,A$1:A$5)
Copied down
Returns 1;1;3;4;5
--
Biff
Microsoft Excel MVP
"Scott" wrote in message
...
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.
|