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: