Hi,
This is my first post on a forum so hoping I've done it all correctly.
I have my data set out in a specific order which is making this more complicated for me but not something I can change.
The result I'm looking for is simply to sum up the values for and against a team for the previous 2 events, however, the difficultly I have is that the column the data I need is in varies depending on whether each game is a home/ away game, and so may the lookup variable depending on how you try and solve it.
I've created a simple and basic unique reference for line of data in the first column to try and aid the process.
I've highlighted and attached an example which I hope explains things better.
I've tried long formulas combining if, sum, sumif, sumifs, row, match, index, and large to name a few but have ran out of inspiration on how to make this work.
I'm running excel 2013.
Thanks very much for your time, help, and input.
Bookmarks