ranking with the same values

[Bill]

does anyone have a solution for unique ranking when 2
cells have the same value. e.g., to have them rank #8,
#8, and then the next cell as rank #10 creates a
problem. I need #8, #9, #10. I've tried some things
which work, but it is not clean. I am looking for a
better method.

Thanks,
Bill

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/rank.htm

 

[Domenic]

Hi Bill,

Assuming your data is in Column A, you could try something like this...

=RANK(A1,$A$1:$A$10)+COUNTIF($A$1:A1,A1)-1

Hope this helps!