# Sequence true or false

#### James Clear

##### Board Regular
I would like to have answer other than v lookup

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

### Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Try this

=ISERR(SEARCH(0,A1))

Or

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

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.

Last edited:
Try this

=ISERR(SEARCH(0,A1))

Or

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

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

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

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

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
AB
101111FALSE
210111FALSE
311111TRUE
411011FALSE
511100TRUE
Sheet941
Cell Formulas
RangeFormula
B1:B5B1=ISODD(LEN(SUBSTITUTE(A1,"0","")))

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

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
AB
101111FALSE
210111FALSE
311111TRUE
411011FALSE
511100TRUE
Sheet941
Cell Formulas
RangeFormula
B1:B5B1=ISODD(LEN(SUBSTITUTE(A1,"0","")))
This is what I was looking for..Thanks a lot

Replies
10
Views
642
Replies
4
Views
301
Replies
5
Views
97
Replies
1
Views
120
Replies
5
Views
95

1,221,153
Messages
6,158,237
Members
451,477
Latest member
CWebbers

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back