Ok, so I have reviewed the information from Twifoo. I am not sure it is what I need. I have attached some information showing parts of my spreadsheet. What I am looking for is this.
In Cell J100, I would like the start date of the first winning or losing streak of the season.
In Cell K100, I would like the end date of the first winning or losing streak of the season.
In Cell L100, I would like a current count of that streak.
In Cell M100, I would like the streak identified as a as a "Winning" or "Losing" streak.
The above is easy. The below is where I cannot figure out how to accomplish in light of the above.
Then in Row 101. I would like to start the process over based on when the above streak ends. So if the team wins from 3/28 - 3/31 with a streak of 3 games, Row 100 would identify 3/28/2019, 3/31/2019, 3, and Winning. Then on 4/1 when the team loses, it would start identifying the date 4/1 and a losing streak of 1 and "Losing".
Each Row would continue to change after the team moves from winning to losing or vice versa.
The streak information can be pulled from the cells in AX - AZ 3 - 164 where I have everything in date order and a win/loss columns that will populate according to the results of each game played.
Please see attached.