OK...got it, now....
How about this:

=RANK(A1,$A$1:$A$10)
Returns the relative position in the list. Note though, the largest
value ranks:1

To get what you posted, this may work for you:
=COUNT($A$1:$A$10)+1-RANK(A1,$A$1:$A$10)

Is that something you can work with?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=504956