Rank

Jez · Mar 3, 2004

How can I use the Rank function in reverse? i.e. if I
have a list of figures, the lowest being the best should
be ranked 1.

Frank Kabel · Mar 3, 2004

Hi
try the following (if A1:A100 stores your values)
=RANK(A1,$A$1:$A$100,1)

this uses the third parameter of the RANK function

Guest · Mar 3, 2004

It's OK I've worked it out...