Finding a streek

Hi,

I'm trying to find out how to return the date or time of a streak occurring in a coin toss.
The streak I'm trying to identify is when a Heads follows a Tails (T following H) more than 4 times in a row:

For example: t t t t h t h t h t h t h t t h h h t h t h

Where the streak is bold.

I have an example sheet attached with the date in column A and the coin flip in B and a 1 & 0 column in C (I was trying to use the 1's and 0's b/c I thought they'd be easier to work with than strings.

Also, there might be some days that no coin is tossed, these days should be skipped.
I'd like to find out when the date of a streak occurs.

Can anyone help with this?

Thanks in advance.

Thanks Martin,

Your series of functions are returning my desired results. I'm still trying to get a grasp on how they actually work and the links you've provided are proving very useful, especially 'why use -- in sumproduct.' I was going about this problem a completely different way, by trying to use a Macro, but my VBA skills are limited (although growing).

Thanks again.