How to filter by multiple columns with OR strings...and nested OR within column?-CodePudding

Using the 'Filter by condition' option, how can you create an 'OR' filter across multiple columns that contains multiple 'OR' strings within the column(s)?

This answer is great for an 'OR' filter for single strings in multiple columns:

=OR(D:D="x",E:E="x")

How can this formula be edited for nested OR query within the column?

E.g. make column D filter on multiple options instead of only "x", such as ("x" OR "y" OR "z")?

CodePudding user response：

try regex:

=FILTER(A2:A; REGEXMATCH(D2:D&""; "x|y|z"))

CodePudding user response：

With FILTER, the "OR" function is written like this:

=FILTER(A2:A;(D2:D="x") (D2:D="y") (D2:D="z"))