Forum Discussion

MarcoTorinoi's avatar
MarcoTorinoi
Copper Contributor
Jan 17, 2024
Solved

Filter Advanced / Multiple criteria / non contain

Hi All   I need to filter out from the column A (a list of emails) all the non business emails.  In the column D I have the criteria (private emails to be excluded). In the real case both column ...
excel
  • djclements's avatar
    djclements
    Jan 17, 2024

    MarcoTorinoi Please see the attached workbook with the list of email provider domains arranged horizontally. With such a huge criteria list, performance may be an issue when applying it to a large dataset. You'll just have to test it to see how well it performs...

djclements's avatar
djclements
Silver Contributor
Jan 17, 2024

MarcoTorinoi When using multiple "does not" criteria with Advanced Filter, you need to use "And" logic by arranging them horizontally on a single row with the column header ("email") repeated for each one:

 

Advanced Filter Does Not Contain List

 

With the criteria listed vertically in a single column you're using "Or" logic, which returns ALL records because <>"*@gmail.*" returns TRUE for all "yahoo" addresses and <>"*@yahoo.*" returns TRUE for all "gmail" addresses (they cancel each other out).