Hi Alex,
I'm working on something that might or might not be what you're after, see attached.
Row 2 are the times (in minutes) of the goals by both teams.
Row 3 works out the sequence of the goals being scored and show in Rows 5&6.
Row 9 works out the nett goals (Home-Away).
Cell V9 works out the max home lead and V10 for home deficit.
Also, Cell V4 works out max consecutive home goals, likewise V5 for the away team.
So, once Row 2 populated for that particular match it should be able to see if the team throw away a commanding 'X' goals lead with 'Y' no of consecutive goals etc.
What do you think?
Alan
Bookmarks