Count Consecutive Occurrences

[dlow]

Hi,

I am trying to count groups of consecutive occurrences. Like puppy might come up 4 times in a row & then not at all, or once or 3 times I would like to count them [consecutive occurrences] & enter the tally in a helper column right next to it. Maybe I am just tired, but my search results didnt bear much fruit in the way of a useable example. Any help is appreciated & thx for your time; Im including a workBook to help convey what Im trying to do more clearly.

[Vikas_Gautam]

Here is your formula..

Please Login or Register  to view this content.

Check the attached file...

[dlow]

Hi, Vikas thx for the quick reply & solution it works, but how could I have the results be aligned to the last or most recent entry? Like in my example workBooks Column B.

[Vikas_Gautam]

Here is an another alternative..

Please Login or Register  to view this content.

Check the attached file..

[dlow]

Perfect!!! You da Man! thx so much. +1Rep Point for you & thx for helping me solve my problem.