Hi all
I have this soccer results with the goals splitted by teams, but i can't find the way to calculate the current winning streaks, the current draw streaks and the current loss streaks.
Note: the most recent results at bottom of the column.
Also i have the formula for calculate the 1st Longest Streak, but how can I get the 2nd, 3rd etc. longest streaks?
any help would be a lot appreciated!
Thanks
matricial formulas used so far:
<v2:v501,row(u2:u501))),if(u2:u501><v2:v501,row(u2:u501))),if(u2:u501>
Win 1st Longest Streak:
=MAX(FREQUENCY(IF(U2:U501<>"",IF(U2:U501>V2:V501,ROW(U2:U501))),IF(U2:U501<=V2:V501,ROW(V2:V501))))
Draw 1st Longest Streak:
=MAX(FREQUENCY(IF(U2:U501<>"",IF(U2:U501=V2:V501,ROW(U2:U501))),IF(V2:V501<>"",IF(U2:U501<>V2:V501,ROW(U2:U501)))))<v2:v501,row(u2:u501))),if(u2:u501>
<tbody>
</tbody>
<v2:v501,row(u2:u501))),if(u2:u501><v2:v501,row(u2:u501))),if(u2:u501><v2:v501,row(u2:u501))),if(u2:u501>sample spreadsheet:
https://mega.nz/#!m9ghBQaY!u1YA8sQJMfzzeEplybHxUnwZn5ty_QDoNXtpFhc9Cqw</v2:v501,row(u2:u501))),if(u2:u501></v2:v501,row(u2:u501))),if(u2:u501></v2:v501,row(u2:u501))),if(u2:u501></v2:v501,row(u2:u501))),if(u2:u501></v2:v501,row(u2:u501))),if(u2:u501></v2:v501,row(u2:u501))),if(u2:u501>
I have this soccer results with the goals splitted by teams, but i can't find the way to calculate the current winning streaks, the current draw streaks and the current loss streaks.
Note: the most recent results at bottom of the column.
Also i have the formula for calculate the 1st Longest Streak, but how can I get the 2nd, 3rd etc. longest streaks?
any help would be a lot appreciated!
Thanks
matricial formulas used so far:
<v2:v501,row(u2:u501))),if(u2:u501><v2:v501,row(u2:u501))),if(u2:u501>
Win 1st Longest Streak:
=MAX(FREQUENCY(IF(U2:U501<>"",IF(U2:U501>V2:V501,ROW(U2:U501))),IF(U2:U501<=V2:V501,ROW(V2:V501))))
Draw 1st Longest Streak:
=MAX(FREQUENCY(IF(U2:U501<>"",IF(U2:U501=V2:V501,ROW(U2:U501))),IF(V2:V501<>"",IF(U2:U501<>V2:V501,ROW(U2:U501)))))<v2:v501,row(u2:u501))),if(u2:u501>
FT Team | FT Opp. |
1 | 3 |
3 | 0 |
0 | 1 |
0 | 1 |
0 | 2 |
0 | 3 |
1 | 2 |
1 | 0 |
2 | 2 |
1 | 1 |
3 | 1 |
2 | 2 |
1 | 2 |
3 | 2 |
3 | 0 |
2 | 2 |
4 | 1 |
3 | 1 |
1 | 0 |
0 | 3 |
1 | 2 |
2 | 1 |
4 | 3 |
1 | 1 |
8 | 0 |
1 | 0 |
2 | 1 |
2 | 0 |
2 | 1 |
2 | 0 |
4 | 0 |
0 | 0 |
0 | 1 |
2 | 0 |
4 | 0 |
4 | 0 |
<tbody>
</tbody>
<v2:v501,row(u2:u501))),if(u2:u501><v2:v501,row(u2:u501))),if(u2:u501><v2:v501,row(u2:u501))),if(u2:u501>sample spreadsheet:
https://mega.nz/#!m9ghBQaY!u1YA8sQJMfzzeEplybHxUnwZn5ty_QDoNXtpFhc9Cqw</v2:v501,row(u2:u501))),if(u2:u501></v2:v501,row(u2:u501))),if(u2:u501></v2:v501,row(u2:u501))),if(u2:u501></v2:v501,row(u2:u501))),if(u2:u501></v2:v501,row(u2:u501))),if(u2:u501></v2:v501,row(u2:u501))),if(u2:u501>
Last edited: