LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
delete both duplicates savbci Excel Discussion (Misc queries) 2 July 23rd 08 03:46 PM
Delete duplicates in a row LM Excel Worksheet Functions 3 July 8th 08 07:20 PM
Delete duplicates? kk Excel Discussion (Misc queries) 2 March 14th 08 02:22 PM
Delete Duplicates Lauren New Users to Excel 4 April 11th 06 05:46 AM
Delete duplicates Carter68 Excel Worksheet Functions 3 June 15th 05 12:01 AM


All times are GMT +1. The time now is 09:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"