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]

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","")))

11110 = This should come as a True situation

 

[Peter_SSs]

You didn't explain your logic behind your TRUE/FALSE requirements,

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

11110 = This should come as a True situation

Why?

 

[Rick Rothstein]

I am not sure what your reluctance is in giving a clear explanation of what you consider a sequence to be, especially in light of all the mis-guessing taking place (kind of ironic I might add given your last name). I am not sure, but it now appears that you consider a sequence to be one or more 1's followed by only 0's thereafter. If that is correct, then give this formula a try...

=(COUNTIF(A1,"*01*")=0)*(A1<>"00000")=1

If my guess is wrong, then I'll wait until either someone guesses what you want correctly or you simply tell us what you consider a sequence to be.

 

[James Clear]

Why?

Coz let us assume customer took a loan in the month of august for the duration of 4 months and hence in the month of December his loan was closed and hence zero

 

[James Clear]

I am not sure what your reluctance is in giving a clear explanation of what you consider a sequence to be, especially in light of all the mis-guessing taking place (kind of ironic I might add given your last name). I am not sure, but it now appears that you consider a sequence to be one or more 1's followed by only 0's thereafter. If that is correct, then give this formula a try...

=(COUNTIF(A1,"*01*")=0)*(A1<>"00000")=1

If my guess is wrong, then I'll wait until either someone guesses what you want correctly or you simply tell us what you consider a sequence to be.

Ok Rick , let me explain in details

In the below example - Let us Customers were given loan for the 5 months

In the first example - Customer was present from Aug to Sep and absent in Nov and again present in Dec so this should come as False coz it's practically not possible

Whereas , 11110 - This is possible since it's possible that in the month of Nov his loan was closed already and hence he was not present

Centre Name	Name of BC	State	BC Branch Code	Aug'21	Sep'21	Oct'21	Nov'21	Dec'21	Combination
ABC	A	KARNATAKA	AB2	Available	Available	Available	Not Available	Available	11101​
PQR	A	KARNATAKA	AB3	Available	Available	Not Available	Not Available	Available	11001​
MNP	A	KARNATAKA	AB4	Available	Available	Not Available	Not Available	Available	11001​

So Answers should be like below

Conc	Status
11011​	FALSE​
11100​	TRUE​
11111​	TRUE​
10110​	FALSE​
11101​	FALSE​
10111​	FALSE​
11110​	TRUE​
10000​	TRUE​
10100​	FALSE​
10001​	FALSE​
11000​	TRUE​
11001​	FALSE​
10101​	FALSE​
10010​	FALSE​
11010​	FALSE​
10011​	FALSE​
1011​	FALSE​
1000​	TRUE​
1010​	FALSE​
1111​	TRUE​
1110​	TRUE​
1100​	TRUE​
1001​	FALSE​
1101​	FALSE​
00111	TRUE​
00100	TRUE​
00101	FALSE​
00110	TRUE​
00010	TRUE​
00011	TRUE​
00001	TRUE​

 

[James Clear]

01011	FALSE
01000	TRUE
01010	FALSE
01111	TRUE
01110	TRUE
01100	TRUE
01001	FALSE
01101

Forgot to mention one zero at starting position

 

[James Clear]

Ok Rick let me try and come back to you soon. Thanks for your assistance with this matter

 

[Rick Rothstein]

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

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

 

[bebo021999]

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))

 

[Rick Rothstein]

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))

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).