ranking a list

  • Thread starter Thread starter Andrew Walsh
  • Start date Start date
A

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
 
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
 
that works a treat!!!

thanks guys


Tom Hutchins said:
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
Click to expand...
 
Back
Top