Hi all,

I was wondering if some or one of you might be able to help with something I'm stuck.

I currently have spreadsheets, like the one attached, that has matches with the goal minutes of each goal, for home and away team. What I would like to end up with is a spreadsheets that tells me how often teams gave up a lead or for example recovered a goal deficit. It would be greatly appreciated if you guys could help as I'm really stuck with this at the moment.

In the spreadsheet are 2 sheets, one with the data and one with the ideal output based on formulas,etc. but obviously any better suggestions would be welcome.

EPL_14-15_1.xlsx

Looking forward to hearing from you.

Many thanks,
Alex