How to sift one data out from one spreedsheet to another

[OMGHelpmeimuseless]

Good Morning folks!

I was wondering if anyone could help me with this little issue!

For example

Spreedsheet A shows a group of people who have numbers associated with their names.

Spreedsheet B shows the same as well.

How would I select the certain member numbers in Sheet B and make sure that Sheet A doesn't have them or filters them out?

Thank you!

[jeffreybrown]

Hello & Welcome to the board,

Is this a one time event were you want to make sure you have one clean list without any duplicates?

[OMGHelpmeimuseless]

Yup this is a one time event.

There are certain members in Spreedsheet B that I don't want in Spreedsheet A. All members have a specific numeric ID to them.

[jeffreybrown]

One way...

Let say your ID's are in column A, place this formula in any other column matching ID's from column A from one sheet against column A from another sheet.

=MATCH(A2,SheetB!$A$2:$A$13,0)

If that ID is in SheetB, then you will get a number, but if not then #N/A.

Know just filter for the numbers and delete.