Long time visitor, first time poster here. I've always been able to work issues out with formulas but for some reason this one is giving me a massive headache. It's been many hours and I'm no closer. So here it is:
Column A2:Ax has a tally for a win("W"), loss("L"), or tie("T") for a card game. I would like to have an area labeled 1-x to show how many win and losing streaks there are. In other words, how many 1 game win streaks, how many 1 game losing streaks, how many 2 game win streaks, how many 2 game losing streaks.......etc.
bandicam 2015-05-08 22-40-48-210.jpg bandicam 2015-05-08 22-43-41-963.jpg
I've tried max(frequency, countifs, etc and nothing is working. This was the latest I tried and it looked promising but when I copied down and then did the "Lose Streak" formula, it all came apart. Here is the losing formula
Thanks for reading!
EDIT: So far there are 650 or so games tallied with a lot more to input.
Bookmarks