Sequence true or false

[James Clear]

I would like to have answer other than v lookup

If sequence is 01111 - False , 10111- false, 11111- True , 11011 - false

 

[StephenCrump]

This formula should work for you...

=COUNTIF(A1,"*1*0*1*")=0

It looks like the OP has a mix of numeric and text values. Hence:

	A	B	C
1	1101	A1 is number	TRUE
2	1101	A2 is text	FALSE
Sheet4

Cell Formulas
Range	Formula
C1:C2	C1	=COUNTIF(A1,"*1*0*1*")=0

 

[Rick Rothstein]

Did you try the corrected

This is testing result at my end, in fact my formula match 100%, but Rick's got 4 fails

Apparently, I had formatted all the data cells in Column A as Text and that is why my formula worked for me but not for you.

EDIT NOTE: Stephen beat me to it by seconds with the same reasoning. It did not occur to me that someone would intermittently mix the two formats.

 

[StephenCrump]

It did not occur to me that someone would intermittently mix the two formats.

Yes, the post marked as the solution returns FALSE for the string '01100, for example, when the required result is TRUE.
But for the numeric 1100 it will return TRUE.

 

[James Clear]

Yes, the post marked as the solution returns FALSE for the string '01100, for example, when the required result is TRUE.
But for the numeric 1100 it will return TRUE.

Hi, Actually just to show on the screen I had to Put ' sign before zero like '0