find repeat data ‎continuous from a list data

[jasmimh]

Hi sir,
i wanna to know how to find repeat data ‎continuous from a list data...
Example; From F6:AJ6 they have data 1,0,0,0,1,1,1.....
I need formula become TRUE result if they have 3 times 0 continuous...

 

[oldbrewer]

0
0
1		######
1
0
1
0
1
0			#######
0			=IF(AND(A3=A2,A3=A1),"cont","")
0	cont
1
1
0
0
0	cont
0	cont
1
1

<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[jasmimh]

thanks oldbrewer for your reply....
i just use OR(COUNTIF(F21:H21,0)=3,COUNTIF(G21:I21,0)=3,COUNTIF(H21:J21,0)=3..........
and it work for me...