Is there any way I can score a list of 10 numbers from 1 - 10?

IE:

52
44
131
63
64
36
28
132
108
80

Can another column score these in order from 1 to 10 (largest number
gets 10, lowest gets 1) without performing a sort?

So it would become:

52 = 4
44 = 3
131 = 9
63 = 5
64 = 6
36 = 2
28 = 1
132 = 10
108 = 8
80 = 7

Grateful for any help!


--
DJ Dusty
------------------------------------------------------------------------
DJ Dusty's Profile: http://www.excelforum.com/member.php...o&userid=16335
View this thread: http://www.excelforum.com/showthread...hreadid=528286