Re: Rank - Increasing Order

Giganews Newsgroups
Subject: Re: Rank - Increasing Order
Posted by:  Bob Phillips (bob.philli…
Date: Wed, 15 Oct 2003


Add ,1 to the end of the RANK formula



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

"Salza" <sal…> wrote in message news:3f8d7f94…
> 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



In response to

Rank - Increasing Order posted by Salza on Thu, 16 Oct 2003