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

 

[James Clear]

Okay, based on your explanation and examples, I believe this formula will do what you want...

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

Couldn't achieve

Conc	Output Required	Rick	bebo021999
11011​	FALSE​	TRUE​	TRUE​
11100​	TRUE​	TRUE​	FALSE​
11111​	TRUE​	TRUE​	TRUE​
10110​	FALSE​	TRUE​	TRUE​
11101​	FALSE​	TRUE​	FALSE​
10111​	FALSE​	TRUE​	FALSE​
11110​	TRUE​	TRUE​	FALSE​
10000​	TRUE​	TRUE​	TRUE​
10100​	FALSE​	TRUE​	TRUE​
10001​	FALSE​	TRUE​	FALSE​
11000​	TRUE​	TRUE​	FALSE​
11001​	FALSE​	TRUE​	TRUE​
10101​	FALSE​	TRUE​	FALSE​
10010​	FALSE​	TRUE​	FALSE​
11010​	FALSE​	TRUE​	FALSE​
10011​	FALSE​	TRUE​	FALSE​
01011	FALSE​	FALSE​	FALSE​
01000	TRUE​	TRUE​	FALSE​
01010	FALSE​	FALSE​	FALSE​
01111	TRUE​	TRUE​	FALSE​
01110	TRUE​	TRUE​	TRUE​
01100	TRUE​	TRUE​	FALSE​
01001	FALSE​	FALSE​	FALSE​
01101	FALSE​	FALSE​	FALSE​
00111	TRUE​	TRUE​	FALSE​
00100	TRUE​	TRUE​	TRUE​
00101	FALSE​	FALSE​	FALSE​
00110	TRUE​	TRUE​	FALSE​
00010	TRUE​	TRUE​	FALSE​
00011	TRUE​	TRUE​	FALSE​
00001	TRUE​	TRUE​	TRUE​

 

[James Clear]

I get 3 wrong results for your formula when tested against the additional examples the OP posted in Message #16.

I think he wants a FALSE if there is one or more 0's between two 1's (see the formula I posted).

Basically , consecutive 0 and 1 would become FALSE

 

[Rick Rothstein]

When I test my formula against your examples, I get the same results you show that you want. Did you adjust the cell reference in my formula to match whatever cell your first value is in?

 

[James Clear]

When I test my formula against your examples, I get the same results you show that you want. Did you adjust the cell reference in my formula to match whatever cell your first value is in?

Nope I didn’t adjust anything

 

[Rick Rothstein]

Nope I didn’t adjust anything

Should you have? What cell is your first piece of data in... A1 or A2 or somewhere else?

 

[James Clear]

Should you have? What cell is your first piece of data in... A1 or A2 or somewhere else?

A1

 

[Rick Rothstein]

Then you needed to change the A2 in my formula to A1 (you did not tell us where the first cell was orginally so I had guessed at A2).

This formula should work for you...

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

 

[bebo021999]

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

 

[bebo021999]

This is my approach:
EITHER (0 then 1) OR (1 then 0 ) => TRUE
If both: (0 then 1) AND (1 then 0 ) => FALSE

 

[James Clear]

is this the logic:
list of 1 then 0 (decreasing) or 0 then 1 (increasing)? Single direction only.

=ISERROR(SEARCH("10",A1)+SEARCH("01",A1))

Superb....