software

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)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.31
5.31
4.53
4.494
4.494
26

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-Proquot; wrote:

gt; In one column, I have a list of 500 or so sorted prices:
gt;
gt; A
gt; 5.30
gt; 5.30
gt; 4.50
gt; 4.49
gt; 4.49
gt; 2.00
gt;
gt; I want to rank these prices, so in the above example, I want to create
gt; a column B that would be:
gt;
gt; 1
gt; 1
gt; 2
gt; 3
gt; 3
gt; 4 (ranking the prices in column A).
gt; How do I do this? Thanks, Nitin Batra (email: ,
gt; cell: 714-488-9584)
gt;
gt;

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