How do I filter a list OUT of data?

I have a long list of customers and sales over 5 years and I'm looking to take certain exports out of the list. I have a list of the customers I want filtered out but as far as I know the advanced filter only filters so that it shows those customers, rather than filtering those customers out and showing me what's left.

I know I can just manually go through the drop down filter and uncheck each customer but that is quite time consuming. There has to be a way to do this like the advanced filter just in reverse so it leaves all the things not on the list IN rather than taking them all out. Thanks in advance for any tips.

You could use a helper column where you can identify those records which should be omitted. It is difficult to propose a specific formula to you based on what you have written above, so it would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon, as this does not work on this forum.

Hope this helps.

Pete

I've made a sample sheet. I wish the list was even close to this short but here's my example

You can use this formula in C2:

=IF(A2="","",IF(ISNUMBER(MATCH(A2,D:D,0)),"",MAX(C$1:C1)+1))

Copy this down as far as you need to. Then you can use this formula in F2:

=IFERROR(INDEX(A:A,MATCH(ROWS($1:1),$C:$C,0)),"")

then you can copy this down until you start to get blanks.

Hope this helps.

Pete