CODEWITHSUNDEEP
google-sheetslogical-operators
user3105127
user3105127

Reputation: 15

Filter and logical operators

EZ stuff but after an hour.. =filter(May15!A:S , May15!E:E="Authorization") is yielding a rich populated sheet. However I can't get OR working! Despite it working elsewhere in the sheet. I'd like other possibilities via the same filter. I tried several including the OR this way

 =filter(May15!A:S , OR(May15!E:E="Authorization" , May15!E:E="bigwhale", May15!E:E="hi"))

.. to no avail. Any help appreciated. Also, I read somewhere the OR could be accessed using a "+" and that sounded like a neat method.. Thanks!

Upvotes: 0

Views: 93

Answers (1)

Max Makhrov
Max Makhrov

Reputation: 18717

One possible way is to use RegEx:

=filter(H:H , REGEXMATCH(E:E,JOIN("|",A1:A3)))

put in A1:A3:

Authorization
bigwhale
hi

This trick is useful when you need to add conditions, just paste one more value in cell A4 and use range A1:A4

Another way is to use plus sign:

=FILTER(H:H,(E:E="Authorization")+(E:E="bigwhale")+(E:E="hi"))

Upvotes: 1

Related Questions