Ranking

[Mike]

Can I use the RANK function backwards, that is to give the
highest number to the highest value? As always thanks in
advance.

Mike

 

[Bob Phillips]

=RANK(A1,$A$1:$A$100,TRUE)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi Mike
use the third parameter of the RANK function. e.g.
=RANK(A1,$A$1:$A$1000,TRUE)