How to do logical "OR" in FILTER?

In the new FILTER function, I want to do a logical OR in the test-array argument. E.g., following the example for FILTER in the Function Browser and Help, I can select entries where the Rep is Julian AND the Genre is Comic with


FILTER(A2:C11, (B2:B11=B5)*(A2:A11=A5),"")


The * comes from the example in the Help.


But let's say I want the rows where the Rep is Julian OR the Genre is Comic (a key feature here is the OR is between different columns)? This should pick up an extra row for Amanda...


There is no example for this but perhaps using "+" is natural...


FILTER(A2:C11, (B2:B11=B5)+(A2:A11=A5),)


That kinda works. I get the spilled array I want, but each cell has a blue warning that says, "The formula uses a Boolean in place of a number.". There is no option to remove this warning. See below



Furthermore, for a very large table, the "+" does not return expected rows.


I'll note that using AND or OR in the test-array does not work. I get an error that says, "All arguments to FILTER must be the same length."


Have I found a bug or should I be doing something else to get a logical OR in the test-array?


Thanks!

MacBook Pro (M1, 2020)

Posted on May 20, 2025 8:20 PM

Reply
3 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How to do logical "OR" in FILTER?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.