Dear All
I have the below data set and want to be able to count between games when the team concedes against the opposition, e.g., in the column 0-15 there is a count of 7 before the first goal conceded and then the second time is 9 before the next time a goal is conceded and so on down each column of time.
Is there a formula that can count the gaps?
I have tried searching frequency, count etc but I can only seem to find formulae that will reach the first count.
Many thanks
I have the below data set and want to be able to count between games when the team concedes against the opposition, e.g., in the column 0-15 there is a count of 7 before the first goal conceded and then the second time is 9 before the next time a goal is conceded and so on down each column of time.
Is there a formula that can count the gaps?
I have tried searching frequency, count etc but I can only seem to find formulae that will reach the first count.
Many thanks
A League Scott Performance.xlsx | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | |||
56 | Date | Opponent | Type | 0-15 | 16-30 | 31-45 | 46-60 | 61-75 | 76-90 | ||
57 | 21-Nov-21 | Macarthur FC | L | 1 | |||||||
58 | 27-Nov-21 | CC Mariners | L | 1 | |||||||
59 | 3-Dec-21 | Western Sydney | L | 1 | 1 | ||||||
60 | 7-Dec-21 | Western United | FFA | ||||||||
61 | 10-Dec-21 | Newcastle Jets | L | 1 | 1 | 1 | 1 | ||||
62 | 14-Dec-21 | Avondale FC | FFA | 1 | |||||||
63 | 19-Dec-21 | Sydney FC | L | 1 | 1 | ||||||
64 | 1-Jan-22 | Adelaide Utd | L | 1 | 1 | 1 | 1 | ||||
65 | 5-Jan-22 | M. City | FFA | ||||||||
66 | 21-Jan-22 | Western United | L | 1 | |||||||
67 | 29-Dec-21 | M. Victory | FFA | 1 | 3 | ||||||
68 | 6-Feb-22 | Macathur FC | L | 1 | |||||||
69 | 9-Feb-22 | M. Victory | L | ||||||||
70 | 12-Feb-22 | Adelaide Utd | L | 1 | |||||||
71 | 15-Feb-22 | Brisbane Roar | L | 1 | |||||||
72 | 19-Feb-22 | Sydney FC | L | 1 | |||||||
73 | 9-Mar-22 | Newcastle Jets | L | 1 | 1 | ||||||
74 | 12-Mar-22 | Brisbane Roar | L | 1 | 1 | ||||||
75 | 18-Mar-22 | Newcastle Jets | L | 1 | 2 | 1 | |||||
Team |