I am making a league table for the Portuguese Primeira Liga. I have the fixture list, onto which I record results for every match day and by manipulation of formulae, this data updates the league table's info such as games played, won, drawn, lost, goal differences...
I'd like it if the info from the fixture list would help me automatically update a sheet that has data for goals scored for each round for each team, as currently, I'm doing it manually and it's tiresome. Any proposed modifications welcome.
Solved by V. A. in 15 mins