I am trying to calculate only the current winning streak for our Bocceball league. Each game can have 1 of four entries in the game results column. 1= win, 0=loss, x=bye and a blank equals a scheduled game that has not been played yet. There can be multiple byes and scheduled games between/after the games won and it should not 'break' the streak. For Example
Team G1 G2 G3 G4 G5 G6 G7 Streak
A 1 0 0 1 1 1 1 3
B 1 1 1 x 0 1 1
C 0 0 1 1 1 3
D 0 0 0 1 1 x 1 3
I only want the formula to determine the streak of the latest number of wins and ignoring if there are no games played or a scheduled bye.
Thank you in advance for any help.
Team G1 G2 G3 G4 G5 G6 G7 Streak
A 1 0 0 1 1 1 1 3
B 1 1 1 x 0 1 1
C 0 0 1 1 1 3
D 0 0 0 1 1 x 1 3
I only want the formula to determine the streak of the latest number of wins and ignoring if there are no games played or a scheduled bye.
Thank you in advance for any help.
Last edited: