Enumerate Higher to Lowest

[DalPai]

Good morning!

I need help with my table.
I have two lines (Raw Score and Relative Rank):

Raw Score	390	100	660	350	310
Relative Rank

<tbody>
</tbody>

And I need the second row to list the numbers from highest to lowest.

Raw Score	390	100	660	350	310
Relative Rank	2	5	1	3	4

<tbody>
</tbody>

Any ideas?

Best Regards

 

[Aladin Akyurek]

In B2 enter and copy across:

=RANK(B1,$B$1:$F$1)

 

[DalPai]

In B2 enter and copy across:

=RANK(B1,$B$1:$F$1)

Worked like a charm

Tnks

 

[Aladin Akyurek]

Worked like a charm

Tnks

Glad to help.