filtering unmatching data

I know how to filter for matching data but I can't find how to filter the data that doesn't match.
Any ideas please?
Thanks,
B.

Bump?
Let me clarify the question: how do I filter two colums of data to return the values that don not match?
Thanks,
B.

Getting a clarification; so if your data is in columns A and B, you want to filter so that A1 <> B1 it shows, if A1 = B1, it's filtered out. Yes?

ChemistB

Hi Chemist,
Yes. Normally, advanced filtering allows me to match a set of values with any matching values in a target array. What I want to see if the ones that don't match.
As an example, I'm attaching a simple spreadsheet with my expected results included.
Thanks for your time on this.
B.

I could not come up with a way to do it automatically with filtering.

I needed a dummy column to get your list. Here's what I did
Data in A and B with complete list in A, starting in row 3
In C3 (and dragging down)

Please Login or Register  to view this content.

What this does is if there is a match between what is in cell A3 with anything in Col B, then it assigns a row number to it (where the first row of data is 1). This eventually gives you a number in column C in every row that does not have a match in B.

Next in D (to get your new list) I put this formula in Cell D3 (dragged down)

Please Login or Register  to view this content.

The first part catches error messages, after that it Indexes the rows in column D with the value in column A.

Does this work for you? I didn't know if you will have teams in B that aren't in A. That will complicate things.

ChemistB