Rank - Increasing Order

  • Thread starter Thread starter Salza
  • Start date Start date
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
 
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)
 
Back
Top