List in order of total

[ukphoenix]

I have a list of 20 random numbers in Column A, what I need is a list to be compiled in Column B showing the highest as 1 and lowest as 20.

A B
2345 4
123 5
3568 3
9732 1
4325 2

This totals change hourly. Dont know if this requires a macro or just a formula in Column B

[pike]

Hi ukphoenix
in B1
=RANK(A1,A$1:A$20)
Fill the foumula down to B20

[ukphoenix]

Thanx Pike, didnt even realise there was such a formula as RANK

[pike]

There are just to many to remember ... I've only probably seen about one ten of them ever used..... and can only use / remember about a tenth of those

[pike]

also remembered

=SUM(1*(A1<=a$1:a$20))-(SUM(1*(B5=a$1:a$20))-1)/2

entered as an array formula