Excel Queston

[MattR]

Is there a formula I can use for the following.

I have a list of numbers in one column and what I would like to do is have an automated column next to it where it gives out a number according to where the previous columns numbers rank, for example say in column b is

1.50
2.56
1.73
3.45
4.20
1.33


what i would like is for column c to give a ranking from top to bottom such as this

COL A COL B
1.50 --- 2
2.56 --- 4
1.73 --- 3
3.45 --- 5
4.20 --- 6
1.33 --- 1


is there a formula I can use in that column to look at this list in column b and work out 1.33 is the lowest up to the 4.20 as highest and rank it (don't want to sort column b, column b will change dependent on what it reads from something else)

[mathare]

Use the RANK() function in column B. So in cell B1 you'd write =RANK(A1, A:A) and that'll give you the rank of cell A1 out of all cells in column A

[vegyjones]

RANK

I looked on the excel help searching with something like
Rank a set of numbers,
and it provided no useful help whatsoever! :mad:

But Mat makes it look so simple :D

[MattR]

Use the RANK() function in column B. So in cell B1 you'd write =RANK(A1, A:A) and that'll give you the rank of cell A1 out of all cells in column A


Thanks Mat, that's perfect.

[MattR]

Mat, is there a way to reverse rank it? From high to low.



Ok, just found it ta!