here you go, I have created a command button based on Rank and Points.
If you do a simple search within excel it will show you how you can record a simple macro. You dont have to have any programming skills, and can be useful to automate tasks.
The simplest thing would be is to record a marco and run the macro via a command button. So that when the table is updated you run the macro and it sorts out the league positions of the football teams.
ps remember using a simple sort largest number to smallest number might not give you the...