Thread: Ranking a list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bri
 
Posts: n/a
Default Ranking a list

Hi

I have a list of values that I need to rank in descending order. Usually
the RANK function is OK, but here is my problem. I need the list to use
'generous' rules. If there is a tie for 2nd, lets say, then I need the next
place to be 3rd, NOT 4th as the RANK function does.

eg
Scores Rank(correct) Rank(wrong)
14.04 1 1
12.665 2 2
12.665 2 2
11.725 3 4
0.000 4 5

Any ideas how I can deal with this situation?

Thanks in advance
Bri