• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power Query Filter Multiple Columns

M

msquared99

Member
How do I create a filter that says IF column A begins with "C" and column D contains "Apples" then exclude that data from the query?

Thanks!
 
msquared99 said:
How do I create a filter that says IF column A begins with "C" and column D contains "Apples" then exclude that data from the query?

Thanks!
Click to expand...

You can use Advanced Filter rules. Start with one of the columns. Click on filter button and go to Equals. This opens filter dialog. Just switch to "Advanced" and you can set up multiple conditions (AND or OR :) ) with different columns.
 
You must log in or register to reply here.
Back
Top