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.

=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