Require help for spreadsheet calculation of longest winning streak

[kamran]

Hello everyone, I'm in need of some dire help for my assignment which is due tmw. Any help would be greatly appreciated. Heres the scenario:

Team X plays a multiple # of games against 4 different opponents: Team A,B,C, and D.

Here are the results, with the Date that team X played, which team they played against (A,B,C, or D), and whether they won or lost which is donated simply by "1":

Date Team Win Lose
Jan 1 A 1 0
Jan 2 C 1 0
Jan 3 D 0 1
Jan 4 B 1 0
Jan 5 D 1 0
Jan 6 C 1 0
Jan 7 A 1 1
Jan 8 B 0 0
Jan 9 C 0 1
Jan 10 B 0 1
Jan 11 A 0 1
Jan 12 D 1 0



Now my question is, whats a good formula that I could use in Excel to display:

i) the start date and end date of team X's longest winning streak?
ii) the start date and end date of team X's longest losing streak?

Any help would be greatly appreciated.

[Bryan Hessey]

Hello everyone, I'm in need of some dire help for my assignment which is due tmw. Any help would be greatly appreciated. Heres the scenario:

Team X plays a multiple # of games against 4 different opponents: Team A,B,C, and D.

Here are the results, with the Date that team X played, which team they played against (A,B,C, or D), and whether they won or lost which is donated simply by "1":

Date Team Win Lose
Jan 1 A 1 0
Jan 2 C 1 0
Jan 3 D 0 1
Jan 4 B 1 0
Jan 5 D 1 0
Jan 6 C 1 0
Jan 7 A 1 1
Jan 8 B 0 0
Jan 9 C 0 1
Jan 10 B 0 1
Jan 11 A 0 1
Jan 12 D 1 0



Now my question is, whats a good formula that I could use in Excel to display:

i) the start date and end date of team X's longest winning streak?
ii) the start date and end date of team X's longest losing streak?

Any help would be greatly appreciated.

answered in your other post.
---