I Need Help

[Mch]

When using rank it assigns duplicates the next higher number in rank.Ho
do you avoid thi

 

[Frank Kabel]

Hi
see your other post

 

[Fable]

Here's a possible solution:

=RANK(C7,C$7:C$16)+COUNTIF(C$7:C7,C7)-1


Fabl