Help filtering out certain company names

[maddoxs]

Good morning all, 

I am attempting to remove the names below in quotations that fall under a column (InvTo BP Name]  - I am not getting the below filter to work for me 

[ShankerV]

Hi @maddoxs 

Please use the below formula.

Replace OR with AND please in your formula.

Input was:

Output:

Many thanks

Shanker V

[Robin_McIntosh]

@maddoxs Another option as long as the field you are filtering always matches a specific name would be as follows.  This option keeps from having to update the filter formula and you can just add/remove names from the exclude list.  So in this example, you have your input data and then an input or list of names to exclude or filter out of the input.

[gaoa]

Hi @maddoxs if you simply change the "OR" in your formula to "AND" the formula will be working as you expected. So when you have multiple conditions to filter instead of one, you're using "AND" to add those conditions together into one filter tool (custom filter) instead of using several consecutive filter tools to accomplish the same result.