D
dblack91
Hi all
Although a relative excel novice, I am trying to complete a spreadshee
which analysis the form of football teams over the most previous si
home games, six away games, and six cumulative games.
I have a tab already populated with fixtures, column D containing th
home team's name, column e containing the home team's score, column
containing the away team's score, Column G containing the away team'
name. (If it helps I can also have a column denoting 'Home win' 'Draw
or 'Away win'.
What I would like, therefore, is for a separate tab to be automaticall
populated where Column C will contain the team name, then column
containing the 6th last home result, column e the 5th last home resul
and so on, going from home, to away fixtures, and finally on
cumulative basis.
Thoughts and help would be appreciated
Although a relative excel novice, I am trying to complete a spreadshee
which analysis the form of football teams over the most previous si
home games, six away games, and six cumulative games.
I have a tab already populated with fixtures, column D containing th
home team's name, column e containing the home team's score, column
containing the away team's score, Column G containing the away team'
name. (If it helps I can also have a column denoting 'Home win' 'Draw
or 'Away win'.
What I would like, therefore, is for a separate tab to be automaticall
populated where Column C will contain the team name, then column
containing the 6th last home result, column e the 5th last home resul
and so on, going from home, to away fixtures, and finally on
cumulative basis.
Thoughts and help would be appreciated