Removing matched data in Excel

[Santha123]

Hi,

Could anyone advise me on how to easily remove data that appears in two separate excel spreadsheets? I have a list of 11,000 names and want to remove from this 737 names that are also in a second list. Basically, I want to end up with the first list minus the 737 names.

I've found some information on 'find unmatched query wizard' but not sure how this works. Merging the lists and running a duplicate check will only remove the name once, when I need it completely out of the list altogether.

Thanks

 

[kgkev]

you could add a Vlookup column on the right of one list.

Anything that doesn't give a N/A error can be deleted - Use a filter.

 

[Santha123]

Thank you,

I'm a real novice in excel. Could you explain this in layman's terms for me please? Would I put both names into the same list as two columns or cross-check as two separate documents?

Thanks, Santha