• 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.

How to apply multiple ‘Does not Equal to’ filter in same column

ThrottleWorks

Excel Ninja
Hi,

I have list of multiple names, from this list I want to filter 5-10 names applying ‘Does not Equal to’ filter.

How do I do this with coding, manually excel allows us to select only 2 criteria.

Can anyone please help me in this.
 
Hi @Marc L sir, thanks for the help, to be honest, I am poor with Advanced Filter. Am checking this and will revert with details.

Have a nice day ahead. :)
 
There's no direct way to filter out more than 2 criteria for Autofilter.

However, what you can do is create array of values excluding your "<>" criteria.
Then use that array as Criteria1.
 
Back
Top