return rating of which number is highest and descending in column
 

i have a large amount of numbers in a column, i want to keep them in the same
order, but in the column next to it i would like the rating of which is the
highest, which is second highest and so on. hope you can help me

return rating of which number is highest and descending in column
 

Assumes your numbers in A1 - A15 put this in B1 and drag down

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



Mike

"andemor" wrote:

i have a large amount of numbers in a column, i want to keep them in the same
order, but in the column next to it i would like the rating of which is the
highest, which is second highest and so on. hope you can help me

return rating of which number is highest and descending in column
 

Also try this,
Put 1 to 15 in A1 to A15
Put Mike's formula in B1 and This formula in C1 =LARGE(A$1:A$15,ROW())
Drag both formulas down to row 15

Now change the data in column A and watch the difference in the
in their returns.

HTH
Martin




"andemor" wrote in message
...
i have a large amount of numbers in a column, i want to keep them in the
same
order, but in the column next to it i would like the rating of which is
the
highest, which is second highest and so on. hope you can help me