|Subject:||Re: Rank - Increasing Order|
|Posted by:||Bob Phillips (bob.philli…@tiscali.co.uk)|
|Date:||Wed, 15 Oct 2003|
Add ,1 to the end of the RANK formula
... 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.
> 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 ..
Rank - Increasing Order posted by Salza on Thu, 16 Oct 2003