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

 

[Phuoc]

Try this

=ISERR(SEARCH(0,A1))

Or

=REPT(1,LEN(A1))=A1&""

 

[Rick Rothstein]

Another way...

=0+A1<11111

Note: The +0 is because I assumed the values are Text to preserve the leading 0. If the values are real numbers custom formatted with 00000 instead, then you can remove the +0.

 

[James Clear]

Try this

=ISERR(SEARCH(0,A1))

Or

=REPT(1,LEN(A1))=A1&""

Thanks for your response

 

[James Clear]

How

Try this

=ISERR(SEARCH(0,A1))

Or

=REPT(1,LEN(A1))=A1&""

Actually 11100 - Should come true ,
=ISERR(SEARCH(0,A1)) getting FALSE with this

 

[Rick Rothstein]

Hmm, just wondering... did my suggestion work for you or not?

 

[James Clear]

Hmm, just wondering... did my suggestion work for you or not?

Nope

 

[jtakw]

Hi,

You didn't explain your logic behind your TRUE/FALSE requirements, so this is my guess, see if this works for you:

Book3.xlsx
	A	B
1	01111	FALSE
2	10111	FALSE
3	11111	TRUE
4	11011	FALSE
5	11100	TRUE
Sheet941

Cell Formulas
Range	Formula
B1:B5	B1	=ISODD(LEN(SUBSTITUTE(A1,"0","")))

 

[Rick Rothstein]

Nope

Then can you explain more clearly what you consider a sequence?

 

[James Clear]

Hi,

You didn't explain your logic behind your TRUE/FALSE requirements, so this is my guess, see if this works for you:

Book3.xlsx
	A	B
1	01111	FALSE
2	10111	FALSE
3	11111	TRUE
4	11011	FALSE
5	11100	TRUE
Sheet941

Cell Formulas
Range	Formula
B1:B5	B1	=ISODD(LEN(SUBSTITUTE(A1,"0","")))

This is what I was looking for..Thanks a lot