Hello good people,
I would like to calculate a lagged value of cells D and E for each HomeTeam and AwayTeam (cells B and C).
In the example that I uploaded, I would like the 'APG lagged1' (cell G) for Brentford at line 14 (date 21/08/2021) to be its latest value occuring at a preceeding date (regardless if home or away) - in the case at hand - line 1 where the HPG is 3.
I hope this is clear enough. I tried a couple of things with offset but did not work as intended.
Thank you!
Bookmarks