I've tidied up the spreadsheet with some dummy data (Columns E to X) for testing and made it slightly more 'users-friendly', see attached. Hidden columns Z to DE are the working part of the spreadsheet.
Column
DF is the final score
DH shows home win, away win or draw.
DI is the max home lead
DJ is the max home deficit
for example, if you select home team (Cell C1) - Man United.
Untitled.jpg
you can see that against QPR they thrown away a 1 goal lead and lost 6-8 eventually.
another example, you can find out all the matches that teams that had thrown away advantages (final result lost/drawn) by de-select the home win on Column DH and '0' on Column DI (i.e. with goal advantages).
Untitled1.jpg
Bookmarks