Form Data Premier League Games In excel

  • Hi Guys,

    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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!