Ranking function

Art · Feb 24, 2004

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 · Feb 24, 2004

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

Frank Kabel · Feb 24, 2004

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

Art · Feb 24, 2004

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

--
Regards
Frank Kabel
Frankfurt, Germany

.