Or, for the inverse ranking:

=RANK(A1,$A$1:$A$10,1)

--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Bob Phillips" wrote in message
...
=RANK(A1,$A$1:$A$10)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Saxman" wrote in message
...
If I had a column of numbers starting in cells A1:A12, such as those
below, could I rank them in another column 1,2,3?
496
471
455
451
530
524
446
422
480
385
414
342