Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Dec 2001
    Location
    Milford, Connecticut
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Check for Duplicates across two workbooks (Excel 2002)

    I have two separate workbooks (files). Each has over 5,000 entries. I believe there are duplicates in the workbooks. How can I compare two different files in Excel to see if there are duplicates? I'm not a programmer and don't really know Access. It would be helpful to keep the files in Excel. I need to do a mail merge with both, but don't want to send the contacts the same info twice.
    Thanks for your help.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Check for Duplicates across two workbooks (Excel 2002)

    See if the discussion <!post=Here,334397>Here<!/post> helps.
    Legare Coleman

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Check for Duplicates across two workbooks (Excel 2002)

    In addition to Legare's link, you could combine the 2 together in 1 worksheet.

    With Advanced filter (data - filter - advanced filter) to you create a copy of the unique entries.

    Steve

  4. #4
    Star Lounger
    Join Date
    Dec 2001
    Location
    Milford, Connecticut
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Check for Duplicates across two workbooks (Excel 2002)

    I tried the download for Compare and it didn't seem to do anything. Could it be it doesn't work on Excel 2003? The page only discusses up to Excel 97. Or am I missing something?

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Check for Duplicates across two workbooks (Excel 2002)

    Did you download the ZIP file?
    Unzip it to a directory?
    Did you open XL and load the addin (tools - addins - browse (find the file and select it)?
    DId you then run the comparison (tools - compare worksheets) select worksheet 1 and worksheet 2, and set the options?

    What problems did you encounter?

    Steve

  6. #6
    Star Lounger
    Join Date
    Dec 2001
    Location
    Milford, Connecticut
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Check for Duplicates across two workbooks (Excel 2002)

    Obviously I needed to do a few extra steps! Thank you for your help. It is working now.

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Check for Duplicates across two workbooks (Excel 2002)

    Glad I could help.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •