View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
scott scott is offline
external usenet poster
 
Posts: 577
Default Auto Numbering Test Scores and want ties to count the same

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.