HELP NEEDED - Deleting all cells from a list that contain any cells from another list for 2010 EXCEL

[sgalasch]

Hi Guys,


I am in need of a little help with a fairly simple task i am having a problem with.


I have 2 lists of names, lets call them "large list' in sheet 1 and "small list" in sheet 2.


The small list contains names that are in the large list that i want deleted from the large list leaving the unmatched names behind.


I know how to delete the blanks from the large list after.


Pretty simple right? I hope so. This is for Excel 2010.


Any help would be appreciated I am a newbie to Excel so a "how to implement" would also be helpful thanks.


Thanks Sean

 

[anglais428]

Quick(ish) manual way - Do a vlookup in the column beside the large list items. Do it so it finds/does not find an item in the small list. In the false statement put it as "AAAAA". Then sort that column A-Z. Any that appear in the list will have the name replicated, any that don't will have AAAAA. So just delete that batch (they should all be at the top).

 

[sgalasch]

Quick(ish) manual way - Do a vlookup in the column beside the large list items. Do it so it finds/does not find an item in the small list. In the false statement put it as "AAAAA". Then sort that column A-Z. Any that appear in the list will have the name replicated, any that don't will have AAAAA. So just delete that batch (they should all be at the top).

Thanks couple quick questions: what is a vlookup?

what is a false statement?

Sorry should of said i have never used excel much before today

I think i need a code solution not that i know how to implement, any help would be great.

Thanks