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, [TABLE="border: 0, cellpadding: 0, cellspacing: 0"]
[TR="class: cke_show_border"]
[TD="width: 67"]Ref[/TD]
[TD="width: 67"]Output[/TD]
[TD="width: 89"]Home[/TD]
[TD="width: 89"]Away[/TD]
[TD="width: 67"]HTHome[/TD]
[TD="width: 67"]HTAway[/TD]
[TD="width: 77"]Date[/TD]
[TD="width: 67"]FTHome[/TD]
[TD="width: 67"]FTAway[/TD]
[TD="width: 67"]HT[/TD]
[TD="width: 67"]FT[/TD]
[TD="width: 67"]HT FT[/TD]
[TD="width: 67"]Away HT[/TD]
[TD="width: 67"]Away FT[/TD]
[TD="width: 75"]Away HT FT[/TD]
[/TR]
[TR="class: cke_show_border"]
1
[/td][td]1
[/td][td]Arsenal
[/td][td]Leicester
[/td][td]2
[/td][td]2
[/td][td]11/08/2017
[/td][td]4
[/td][td]3
[/td][td]D
[/td][td]W
[/td][td]DW
[/td][td]D
[/td][td]L
[/td][td]DL
[/td]
[/TR]
[/TABLE]
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, [TABLE="border: 0, cellpadding: 0, cellspacing: 0"]
[TR="class: cke_show_border"]
[TD="width: 67"]Ref[/TD]
[TD="width: 67"]Output[/TD]
[TD="width: 89"]Home[/TD]
[TD="width: 89"]Away[/TD]
[TD="width: 67"]HTHome[/TD]
[TD="width: 67"]HTAway[/TD]
[TD="width: 77"]Date[/TD]
[TD="width: 67"]FTHome[/TD]
[TD="width: 67"]FTAway[/TD]
[TD="width: 67"]HT[/TD]
[TD="width: 67"]FT[/TD]
[TD="width: 67"]HT FT[/TD]
[TD="width: 67"]Away HT[/TD]
[TD="width: 67"]Away FT[/TD]
[TD="width: 75"]Away HT FT[/TD]
[/TR]
[TR="class: cke_show_border"]
[/TR]
[TR="class: cke_show_border"]
194
[/td][td]20
[/td][td]Liverpool
[/td][td]Swansea
[/td][td]1
[/td][td]0
[/td][td]26/12/2017
[/td][td]5
[/td][td]0
[/td][td]W
[/td][td]W
[/td][td]WW
[/td][td]L
[/td][td]L
[/td][td]LL
[/td]
[/TR]
[/TABLE]
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! [ATTACH]n1206384[/ATTACH]
Any questions let me know.
Cheers!