Hi All,

For the past four seasons I have run a football tournament using Excel, but having to update the league tables manually and also having to sort them (rank them) manually and individually after each update of results.

I was wondering if there was anyone that could help, where by just inputting the score on the fixtures tab it will automatically update the League Table for that specific group. I have attached the spreadsheet I am currently using and if anyone can help in any way it will be very much appreciated.
As an example, the 1-1 scoreline shown in cell B3, represents a score from Group A - Under 11s, I would like that to be updated automatically on the Group A - Under 11s League Table, with the rank of the teams updating with teams moving up or down the league table. The table is to be ranked in order of most points, followed by GD (goal difference).

Hopefully someone can help!

Tournament Workbook.xlsx

Thanks