I am looking to calculate the form for a team in my sheet based on the last 4 fixtures.
For example, for Liverpool playing on Boxing day, I want a new excel column telling me the last 4 results, i.e. W,W,L,D, this can come in numbers, i.e. a 3 for win, 0 for loss, 1 for a draw, if I a had a number say 7, I would know that their form is W W L D.
I can dothisusing simple formulas if I split the, teams, individually, i.e. a section of Liverpool, a section for Chelsea, but I would like to be able to do it for the entire sheet quickly as I have a few sheets I want to do it for.
I have uploaded the sheet.
Any help would be appreciated.
I am struggling to upload the file but its at this url called Premier League http://www.football-data.co.uk/mmz4281/1718/E0.csv