Match numbers in 2 columns

[thedeed]

I have looked for a solution to this issue for several days and figured I would ask before they need to admit me to my local mental hospital .

I have a excel 97 spreadsheet with 2 columns. In column 1 I have all the numbers (17000 Plus) and in column two it has some of the number but not all (10,000 Plus). Here is the question.

Is there a formula that says If the same numbers can be found in both columns then delete those rows. So this will leave only what is not in column 2 in column 1

Thanks in advance for any help on this!!

Spreadsheet Im working with

 

[Joe4]

Welcome to the Board!

You can use a VLOOKUP formula to look up values from one list to the other. If it does not find a match, it will return an error. If you sort by this new columns of formulas, all the errors will be bunched together, then you can delete those without errors and be left with your unmatched set.

Take a look at the VLOOKUP function in Excel's built-in help files if you need details and examples.

By the way, if you have Microsoft Access, this is even easier! There is a built-in Wizard to do "unmatched queries".