How to create column of ranks.

[nbatra]

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: (e-mail address removed),
cell: 714-488-9584)

 

[Guest]

Before we get fancy, is this something you can use?:

Using your list in Cells A1:A6
B1: =RANK(A1,$A$1:$A$6)
Copy that formula down.

The results will be this:
5.3 1
5.3 1
4.5 3
4.49 4
4.49 4
2 6

Note the lack of a 2nd and 5th rank....Excel grants ties the same rank and
reserves placeholders for the missing items.

Acceptable? Yes? No?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[nbatra]

Yes, thanks! Let me know if you ever need a job, man!