ranking with the same values

  • Thread starter Thread starter Bill
  • Start date Start date
B

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
 
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!
 
Back
Top