Hi Guys,
I have a spreadsheet with lots of football scores, I have attached it so you know what I'm talking about.
Here is one of the entries,
<tbody style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; vertical-align: baseline;">
</tbody>
So from this, I know that Arsenal Won the Game 4-3.
I have a long list of results like this,
What I want to do, is known the previous form before a game, so for example, on Boxing Day, Liverpool Played Swansea,
<tbody style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; vertical-align: baseline;">
</tbody>
I would like to know the form of Liverpool and Swansea in the last 6 games, for example, was Liverpools form W W W W W W, did they win all the last six games.
I will eventually be putting this information in number form, i.e. (3 for a win, 1 for a Draw, 0 for a Loss), so for example, a score of 18 for liverpool would mean that they won the last three.
The games can be home and away, I want to know the form of the last 6 games, regardless of whether it was home or away.
I also want to be able to drag the formula down, so then I can enter next weeks fixtures and get the form data based on the past form.
I have seen lots of people make a form table, the different with mine is I want to know them form at each fixture throughout the season.
It would be handy if the formulas could easily be adapted to check the form of the last 3 games also - if it is easy! Prem.xlsx
Any questions let me know.
Here is the link for the data http://www.football-data.co.uk/mmz4281/1718/E0.csv
Cheers!
I have a spreadsheet with lots of football scores, I have attached it so you know what I'm talking about.
Here is one of the entries,
| Ref | Output | Home | Away | HTHome | HTAway | Date | FTHome | FTAway | HT | FT | HT FT | Away HT | Away FT | Away HT FT |
| 1 | 1 | Arsenal | Leicester | 2 | 2 | 11/08/2017 | 4 | 3 | D | W | DW | D | L | DL |
<tbody style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; vertical-align: baseline;">
</tbody>
So from this, I know that Arsenal Won the Game 4-3.
I have a long list of results like this,
What I want to do, is known the previous form before a game, so for example, on Boxing Day, Liverpool Played Swansea,
| Ref | Output | Home | Away | HTHome | HTAway | Date | FTHome | FTAway | HT | FT | HT FT | Away HT | Away FT | Away HT FT |
| 194 | 20 | Liverpool | Swansea | 1 | 0 | 26/12/2017 | 5 | 0 | W | W | WW | L | L | LL |
<tbody style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; vertical-align: baseline;">
</tbody>
I would like to know the form of Liverpool and Swansea in the last 6 games, for example, was Liverpools form W W W W W W, did they win all the last six games.
I will eventually be putting this information in number form, i.e. (3 for a win, 1 for a Draw, 0 for a Loss), so for example, a score of 18 for liverpool would mean that they won the last three.
The games can be home and away, I want to know the form of the last 6 games, regardless of whether it was home or away.
I also want to be able to drag the formula down, so then I can enter next weeks fixtures and get the form data based on the past form.
I have seen lots of people make a form table, the different with mine is I want to know them form at each fixture throughout the season.
It would be handy if the formulas could easily be adapted to check the form of the last 3 games also - if it is easy! Prem.xlsx
Any questions let me know.
Here is the link for the data http://www.football-data.co.uk/mmz4281/1718/E0.csv
Cheers!
