Managing Lists

[Listcoop]

Hello All,

I'm new to the Forum....looks like a good place to up my Excel IQ...I can use it.

I have a list of email addresses in LIST A, which I would like to remove from a much larger LIST B. Is there is simple, automated way to do this?

The email addresses in LIST A appear randomly throughout LIST B, so removing them by deleting them hand would be a major chore.

Thanks in advance for any input you guys/gals can offer.

 

[Smitty]

Welcome to the Board!

See this MSKB Article: http://support.microsoft.com/kb/240077

ASAP Utilities also has a Duplicate removal tool.

HTH,

 

[pagrender]

Welcome to the Board.

What version of Excel are you using? In 2007 there is a REmove Duplicates option which might work for you if you combine the two lists into one.

 

[Listcoop]

See this MSKB Article: http://support.microsoft.com/kb/240077

Thanks!

I'm using Excel 2007

The article looks like it should have the solution because It contains: "how to delete duplicate records after comparing one list against another"

...hopefully the instructions between v2000 and v2007 do not vary much.

 

[Smitty]

..hopefully the instructions between v2000 and v2007 do not vary much.

Shouldn't be an issue.