So, there are a lot of questions related to displaying a cell with the current winning or losing streak for a team.
There are also a lot of variations in the way people have their data setup and this affects the formula needed to retrieve what is needed.
My data set has the streak displayed with a 1 for a win and a 0 for a loss and a .5 for a tie. The data is all contained in 3 rows as follows:
<tbody>
</tbody>
What I am looking for is a way to calculate the formula in column J so that the streak is displayed. If my data increased by 1 more column as follows, the output in column j would be automatically updated to show:
<tbody>
</tbody>
Thanks in advance.
There are also a lot of variations in the way people have their data setup and this affects the formula needed to retrieve what is needed.
My data set has the streak displayed with a 1 for a win and a 0 for a loss and a .5 for a tie. The data is all contained in 3 rows as follows:
a | b | c | d | e | f | g | h | i | j |
1 | 0 | 1 | .5 | 1 | 1 | 1 | 1 | W4 | |
0 | 0 | 0 | 0 | 1 | 1 | 0 | .5 | T1 | |
1 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | L2 |
<tbody>
</tbody>
What I am looking for is a way to calculate the formula in column J so that the streak is displayed. If my data increased by 1 more column as follows, the output in column j would be automatically updated to show:
a | b | c | d | e | f | g | h | i | j |
1 | 0 | 1 | .5 | 1 | 1 | 1 | 1 | 0 | L1 |
0 | 0 | 0 | 0 | 1 | 1 | 0 | .5 | 1 | W1 |
1 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | W1 |
<tbody>
</tbody>
Thanks in advance.
Last edited: