Hi

I am trying to count the number of times a team has scored consecutive occasions, but struggling to generate a formula as the data is not ordered. On the spreadsheet attached, Cell H28 would be looking for the number of consecutive times "Manchester United" appeared in the cells above B28 in instances where D28 is =1.

Would be extremely grateful if anyone had any suggestions?

Thanks.

PL results.xlsx