Exclusion Filtering in Excel Advanced Filter

Question

I cannot get the advanced filter system on excel to exclude a set of criteria like I can include.

So this is the data I have in a table.

Now I click Filter, Advanced, and then under criteria I go into a new sheet with the same headers and the formulas ="<>Director", ="<>Vice President", etc

It looks like this

HOWEVER, it doesn't end up excluding the terms I list! When I do the opposite and use it for inclusion filtering it works like a charm. I just cannot get the opposite to work.

I appreciate all the help!

Solution

First you have to write the Criteria in another way, and if you want to include Director ...(each Title starting by Director) and the same for Vice President use:

Title           Title            Title                  Title  
<>*Director*    <>*Manager*     <>Vice President*       <>VP*  

Because you need only the Titles that are <>Director* and <>Manager* and <>Vice President*
When you write in 2 Rows it means OR
In 2 columns it means And

If you want to copy to another sheet:

• Start the Advanced Filter from the sheet which you want to copy to
• Click on copy to another Location
• In copy to box select the cell where you want to start the result
• Click in the box of List Range go to the initial sheet and select your Data
• Click in the box of Criteria Range, go to where you wrote the 3 columns with Title and select the 6 cells (3 columns * 2 Rows)

• Click OK