2nd & 3rd

[excelhasey]

In Excel you can select a range of cells and find the 1st, 2nd, 3rd, 4th, 5th lowest etc value using Rank, which seems to sort from the lowest to the largest

Is there an Inverse Rank or something like that which ranks things from the highest value down to the lowest etc ??

[Castillo]

Hi

Have a look at this post...

http://www.gruss-software.co.uk/forum/v ... php?t=3138

Hope this helps,

Cheers
Castillo

[osknows]

The RANK function has order capability built in

=RANK(number,ref,order)

=RANK(A1,A1:A10,0) ranks descending
=RANK(A1,A1:A10,1) ranks asscending

If order is 0 (zero) or omitted, Microsoft Excel ranks number as if ref were a list sorted in descending order.

If order is any nonzero value, Microsoft Excel ranks number as if ref were a list sorted in ascending order.

[excelhasey]

Oh so simple Os you do know !!!

Thanks alot