Enumerate Higher to Lowest

[DalPai]

Good morning!

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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Raw Score[/TD]
[TD]390[/TD]
[TD]100[/TD]
[TD]660[/TD]
[TD]350[/TD]
[TD]310[/TD]
[/TR]
[TR]
[TD]Relative Rank[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Raw Score[/TD]
[TD]390[/TD]
[TD]100[/TD]
[TD]660[/TD]
[TD]350[/TD]
[TD]310[/TD]
[/TR]
[TR]
[TD]Relative Rank[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]

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.