I Need Help

Mch · Aug 22, 2004

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

Frank Kabel · Aug 22, 2004

Hi
see your other post

Fable · Aug 23, 2004

Here's a possible solution:

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

Fabl