Help please, trying to get a function to detect 4 cells in a row.

[KatenKotsu]

I'm trying to get Microsoft Excel to check to see if this variable is true or not. Example would be that I would flip 10 coins and what I'd need it to do is to get it to tell me that if somewhere within those 10 coin flips, if 4 of them where in a row (not total).

Example would be: (H for Heads, T for Tails)

THTTHHHHTTT <--- How would I get Excel to look at that (in 10 different cells going from A-J) and tell me "yes, no, true or false?

Thank you for taking the time to read this.

[Cutter]

Duplicate thread: http://www.excelforum.com/excel-gene...-in-a-row.html

[Ace_XL]

Good day,

Firstly, in column K get all values of A-J together using

Please Login or Register  to view this content.

Then use the following to determine whether there are 4 consecutive instances

Please Login or Register  to view this content.