Recognizing a pattern of 0's

I am working on a simulation problem for a class. I am simulating a simple game where you flip a coin 10 times, Heads = 0, Tails = 1. To win the game, I need to flip 4 heads (0's) in a row. How can I get Excel to recognize four 0's in a row? I can generate the random numbers (=RANDBETWEEN(0,1)) but I can't figure out the right formula to generate a True (win) or False (lose) output. An example would be:
0 1 0 1 0 1 0 1 0 1 = Loss
1 1 0 1 0 1 0 0 0 0 = Win

I think I could do it using IF/AND functions but I think it would get pretty complicated doing it that way.

If your 1,s and 0's are in the same cell,

Formula:

Please Login or Register  to view this content.

I would probably try a =COUNTIF() function in a helper row. If random numbers are in A1:J1
A2=COUNTIF(A1:D1,0) and copy across. Note the relative references.
M2=(COUNTIF(A2:J2,4)>0) M2 returns TRUE for win and FALSE for loss.

Have you tried FREQUENCY comparing 0s with non-0s?

Starting with something like this:

=FREQUENCY(IF(A1:J1=0,COLUMN(A:J)),IF(A1:J1<>0,COLUMN(A:J)))

Try this ...

=IF(SUMPRODUCT(--(A1:G1&B1:H1&C1:I1&D1:J1="0000")),"Win","Loss")

A follow up afterthought.

Try array entering this. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

Please Login or Register  to view this content.