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