View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dude dude is offline
external usenet poster
 
Posts: 4
Default Delete duplicates on 2nd workbook

I have 2 workbooks with contact information as follows;

company address city state zip phone
contact
123 co. anystreet anyttown tx 12345 (123)456-7890 joe smith

One is the 2008 listing, and the 2nd one is the 2009 listing.

Both lists contain over 200k entires.

I need to compare the 2, and delete all duplicate entries in the 2009 list,
leaving only the new additions in 2009 to work with.

Is this possible in excel, or do I need to get Access now?