How to rank data in excel

[abberyfarm]

Hi there,

How would rank data in excel. See in the example there are numbers in Col A, how could you automatically rank these numbers in Col B?

Excel Workbook
	A	B
1	3	1
2	8	5
3	4	2
4	6	3
5	7	4
Sheet1

Thank you

 

[enttoobad]

There is an excel RANK function:

in C1 put:

=RANK(A1,$A$1:$A$5)

and copy the formula down the range..

 

[mmmarks]

try dis in B1 and drag down
=RANK(A1,$A$1:$A$5,1)

 

[abberyfarm]

Thats easy thanks guys!