Rank - Increasing Order

Giganews Newsgroups
Subject: Rank - Increasing Order
Posted by:  Salza (sal…@tm.net.my)
Date: Thu, 16 Oct 2003

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 ..