All your formulae fit my use, thank you Teethless, Valko & Bernd.




"Teethless mama" ...
RANK is an obsolete function, I suggest.

Not so fast...

You can use RANK()+COUNTIF()-1. This formula is few characters shorter and
more elegant than your formula

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

is the same result as:

=COUNTIF($A$1:$A$99,""&A1)+COUNTIF(A$1:A1,A1)


"Bernd P" wrote:

Hello Kent,

Do not use RANK, use instead:
=COUNTIF($A$1:$A$99,""&A1)+COUNTIF(A$1:A1,A1)
and copy down.
If identical values should get identical ranks, substitute the second
term by 1.

This formula can deal with number AND with strings. RANK is an
obsolete function, I suggest.

Regards,
Bernd
.