Updating League Tables automatically by inputting Results

[bm2]

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

[protonLeah]

You did not put any values or formulas in the table to indicate how that "1-1" is used to populate it.

[micope21]

Hi

To put in same cell 1-1 will course problem sometime!!
Best to add other column?
Sample
column A, team
column B, score
column C, score
column D, team

Use sumproduct and a DUMMYTABLES sheet in order get automatic on TABLES sheet.

I done Under 11 and 11? Learn formula and see you can work on under 14 and 15?

Any problem pm me.

See the file.

Regard

[bm2]

This is exactly what I was looking to do! Excellent!

I will try and learn the formula and try with Under 14s and Under 15s and let you know any problems.

Thanks!