How do filter multiple criteria in multiple columns when advanced filter is not an option

[nor303]

Hi

I have a table where I want to keep the rows if one of these two criterias are meet in two of the columns. They are not dependent on each other so its important that if one of the criteria is true the rows shall be kept. Im trying to this in Excel Query.

	Customer	YES or NO	Product
1	A	YES	-
2	B	NO	ABC
3	C	YES	BCG
4	D	NO	-
5	E	NO	DCG
6	F	YES	-

In this example only row 4 shall be excluded. 

Any help is much appreciated!

[Mkarwa-123 · Accepted solution]

Hello @nor303 Use custome colum. Create a flag based on flag =0 filter table.

Did I answer your question? Mark my post as a solution! Kudos are appriciated.

[nor303]

Thanks!