Re: Rank - Increasing Order

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

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)

"Salza" <sal…@tm.net.my> wrote in message news:3f8d7f94…@news.tm.net.my...
> 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

Replies

None

In response to

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