Forum Discussion

nor303's avatar
nor303
Helper III
3 years ago
Solved

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

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
1AYES-
2BNOABC
3CYESBCG
4DNO-
5ENODCG
6FYES-

In this example only row 4 shall be excluded. 

 

Any help is much appreciated!

Need Help
  • Mkarwa-123's avatar
    Mkarwa-123
    3 years ago

    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.



2 Replies

  • Mkarwa-123's avatar
    Mkarwa-123
    Resolver II
    3 years ago

    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.