ranking a list

[Andrew Walsh]

Hi,

I have very little knowledge of Excel but am trying to rank a list of
numbers in a row (in the row below).
I want the highest number to be 1, the second highest to be 2, etc. each
number is in a different column.

for example:

row1 45 12 1 63 14 56 15

I want to become

row1 45 12 1 63 14 56 15
row2 3 6 7 1 5 2 4

I do not want the numbers in row1 moved.
Also, the numbers in row1 could change therefore their 'ranking' will also.


Anyone got any ideas on getting me started.
Thanks

 

[Ragdyer]

Try this in A2, and copy across:

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

 

[Guest]

Assuming your row 1 data begins in column A, in cell A2 enter:

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

Copy this formula across through column G.

Hope this helps,

Hutch

 

[Andrew Walsh]

that works a treat!!!

thanks guys

Assuming your row 1 data begins in column A, in cell A2 enter:

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

Copy this formula across through column G.

Hope this helps,

Hutch