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

	Maths	English	Physics	Chemistry	Total Score	Ranking
James	80	89	81	87	337
David	75	80	78	80	313
Moses	78	80	82	76	316
Scott	87	87	76	88	338
Segun	76	78	86	77	317

<colgroup><col span="3"><col><col><col><col></colgroup><tbody>
</tbody>

 

[James006]

Hello,

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

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

Hope this will help