Formula to identify streaks from a Data Set of Results

Hi Marvin,

I'm not sure that would work, as I have columns D and F on that sheet geared to a Solver model and a VLOOKUP table (I'm thinking though that I could just set this up as a separate worksheet for streak analysis as a way round this?).

I've attached the sheet that I'm interested in doing this on - as an FYI the Probabilities tab is rough working at the moment as is the Data Sheet tab.

I'm quite happy to bounce something back and forth (I hope this gives you an idea of where I am going with this).