Result certain cols only , True False function

[Sunline]

Hello all ,

Im wanting to get a TRUE FALSE function that will only look at the cols I want , not a range as such .

As per sample sheet my results col E , in this case I only want to look at cols A B D , not col C .

I want to add a few more cols than the 3 in sample but don’t know how to do this

Thanks .

Excel Workbook
	A	B	C	D	E
1	1	2	3	4	Result
2	FALSE	FALSE	FALSE	FALSE	FALSE
3	TRUE	FALSE	FALSE	TRUE	TRUE
4	FALSE	TRUE	FALSE	FALSE	TRUE
5	FALSE	FALSE	TRUE	FALSE	FALSE
6	FALSE	FALSE	FALSE	TRUE	TRUE
7	FALSE	FALSE	FALSE	FALSE	FALSE
8	FALSE	TRUE	FALSE	FALSE	TRUE
9	TRUE	TRUE	FALSE	FALSE	TRUE
10	FALSE	FALSE	FALSE	FALSE	FALSE
11	FALSE	FALSE	TRUE	FALSE	FALSE
Sheet1

 

[Aladin Akyurek]

E2, control+shift+enter, not just enter:

=ISNUMBER(MATCH(TRUE,CHOOSE(ROW(INDIRECT("1:"&COUNTA(A2,B2,D2))),A2,B2,D2),0))

 

[Sunline]

Thanks again Aladin works perfectly .
Thankyou .

 

[Peter_SSs]

Does not a simple adaptation of Aladin's OR formula as provided here, & noting the subsequent confirmation that Ctrl+Shift+enter is not required, suffice for your needs?

=OR(A2:B2,D2)

 

[Aladin Akyurek]

Thanks again Aladin works perfectly .
Thankyou .

You are welcome. But note...

Does not a simple adaptation of Aladin's OR formula as provided here, & noting the subsequent confirmation that Ctrl+Shift+enter is not required, suffice for your needs?

=OR(A2:B2,D2)

How true!