Count Number of Series

Hiya,

I'm trying to count the number of times a series occurs in a row so I can see each time we've been at a level (0 - 4).

I've attached the spreadsheet I'm working on so this makes more sense

Any help would be great

Originally Posted by JohnTopley

Please add some manually-calculated expected results.

Find attached :-)

not sure I agree / follow all of your expected results (i.e. inconsistency where solitary values are included/excluded from "series" count) however, you might try something like:

Formula:

Please Login or Register  to view this content.