Ranking function

[Art]

Say I have a row containing integers, such as:

Integer 12 20 9 6 15

Is there a way with functions to calculate the ranking
index of each integer, from highest to lowest, and display
the results in the row below?

Integer 12 20 9 6 15
Rank 3 1 4 5 2

Art

 

[Frank Kabel]

Hi
use RANK.e.g.
RANK(A1,A1:$A$1:$E$1)
and copy to the right

 

[Frank Kabel]

Hi
sorry a typo. Make this
RANK(A1,$A$1:$E$1)

 

[Art]

-----Original Message-----
Hi
sorry a typo. Make this
RANK(A1,$A$1:$E$1)


--
Regards
Frank Kabel
Frankfurt, Germany


.