Rank - Increasing Order

S

Salza

Hello everyone,

I used the formula below to rank the values in column AN.

=IF(RANK($AN$7:$AN$56,$AN$7:$AN$56))

Rank 1 goes to the largest value in column AN etc etc

What changes to the formula should I make so that rank 1 goes to the
smallest value.


Thanks ..

Salza
 
B

Bob Phillips

Salz,

Add ,1 to the end of the RANK formula

--

HTH

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