Display only the numbers that don't match

[RChicken]

In one column i have all my part numbers, and in a 2nd column i have all the part numbers from a manufacture. How can i display the number that i don't have?

[VBA Noob]

Hi,

This site should help

http://www.cpearson.com/excel/duplicat.htm

VBA Noob

[RChicken]

that site is for duplicate entries in the same column, i'm looking for something similar to this, but i need to read data from two seperate columns.

[VBA Noob]

Did you look at the part about

Extracting Values Common To Two Lists

or

Extracting Values On One List And Not Another


VBA Noob

[RChicken]

i'm not really understanding what this is trying to do, i just want to sort out my numbers and delete the numbers i already have.

[VBA Noob]

No Problem

VBA Noob

[RChicken]

No Problem

VBA Noob

sorry i edited my post after you posted this, i'm still having some issues.

[VBA Noob]

Can you post an example of data and expected results

VBA Noob

[RChicken]

i attached the file, this is in tab delmited

[VBA Noob]

Does this help

VBA Noob

[RChicken]

Does this help

VBA Noob

that is a huge help, thanks again VBA Noob!!!

[VBA Noob]

No Problem

VBA Noob