In one column, I have a list of 500 or so sorted prices:

A
5.30
5.30
4.50
4.49
4.49
2.00

I want to rank these prices, so in the above example, I want to create
a column B that would be:

1
1
2
3
3
4 (ranking the prices in column A).
How do I do this? Thanks, Nitin Batra (email: ,
cell: 714-488-9584)