Auto Ranking by Total Score

[seuntoba]

Hello-


I want to Auto Rank a list by a Total Score column. The current table was generated using formulas from another sheet
that can allow additional rows. I also want to make sure any new or deleted records get reflected in this final table.

Thank you

[TABLE="width: 490"]
<colgroup><col span="3"><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD] Maths[/TD]
[TD]English[/TD]
[TD]Physics[/TD]
[TD]Chemistry [/TD]
[TD]Total Score[/TD]
[TD] Ranking[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]337[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]David[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]313[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Moses[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]316[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Scott[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]338[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Segun[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]317[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[James006]

Hello,

You could have in cell G2 ... the following formula:

=RANK(F2,$F$2:$F$6)

Hope this will help