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.