=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