=RANK(A1,$A$1:$A$12) and fill down

"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