Find individual/alternative winning streak between two teams. For Google Sheets.

[Wraith2102]

Hi, I need help with finding the longest streak. There are two players A and B competing. We need to find: 1. The streak of A's and B's individual longest streak against each other 2. The longest alternate win streaks starting from A and B respectively. I have filled the first few cells of the file to help you understand better. Thank you.

 

[Wraith2102]

I found the solution for 1st and 2nd part

 

[Fluff]

Is this for Excel or Google Sheets?

 

[Wraith2102]

Is this for Excel or Google Sheets?

Assignment

Sheet3 Consecutive WIns for B,Consecutive WIns for A,Alternative Wins Starting from A,Alternative Wins,Alternative Wins Starting from B 0,0,0,0,0 221208235953,B,1,0,0 221308000111,B,2,0,0 221308000227,B,3,0,0 221308000346,B,4,0,0 221308000507,B,5,0,0 221308000628,A,0,1,1 221308000749,B,1,0,2 221...

docs.google.com

 

[Fluff]

You haven't answered my question.

 

[Wraith2102]

It is for Google Sheet

 

[Fluff]

In that case you need to make that clear initially & such questions should be posted in the General Discussion & Other Applications section of the board.
I have done it for you this time.