• Check for Duplicates across two workbooks (Excel 2002)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Check for Duplicates across two workbooks (Excel 2002)

    Author
    Topic
    WSdaz621
    AskWoody Lounger
    April 5, 2004 at 6:29 pm #403279

    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.

    Reply | Quote
    Viewing 3 reply threads
    Author
    Replies
    • H. Legare Coleman
      AskWoody Plus
      April 5, 2004 at 6:33 pm #809884

      See if the discussion Here helps.

      Reply | Quote
      • WSdaz621
        AskWoody Lounger
        April 6, 2004 at 6:59 pm #810881

        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?

        Reply | Quote
        • WSsdckapr
          AskWoody Lounger
          April 6, 2004 at 11:06 pm #811036

          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

          Reply | Quote
          • WSdaz621
            AskWoody Lounger
            April 7, 2004 at 2:23 pm #811371

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

            Reply | Quote
          • WSdaz621
            AskWoody Lounger
            April 7, 2004 at 2:23 pm #811372

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

            Reply | Quote
        • WSsdckapr
          AskWoody Lounger
          April 6, 2004 at 11:06 pm #811037

          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

          Reply | Quote
      • WSdaz621
        AskWoody Lounger
        April 6, 2004 at 6:59 pm #810882

        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?

        Reply | Quote
    • H. Legare Coleman
      AskWoody Plus
      April 5, 2004 at 6:33 pm #809889

      See if the discussion Here helps.

      Reply | Quote
    • WSsdckapr
      AskWoody Lounger
      April 5, 2004 at 6:38 pm #809906

      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

      Reply | Quote
    • WSsdckapr
      AskWoody Lounger
      April 5, 2004 at 6:38 pm #809907

      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

      Reply | Quote
    Viewing 3 reply threads
    Reply To: Check for Duplicates across two workbooks (Excel 2002)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.