descending order of a series of data
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
.
|