Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Comparing 2 sheets to find differences

    I've got two worksheets each with around 700 rows. They are lists of contact and policy information. The policy number (text) is unique to each row and I need to know what is in sheet A that is not in sheet B and what is in Sheet B that is not in sheet A. Is there an easy way to do this. I'm familiar with Access and it would seem that a simple SELECT FROM A NOT IN B would work, but how is this accomplished in Excel. TIA

  2. #2
    Join Date
    Oct 2003
    Here is a thread that provides both a formula approach and VBA approach.

    Compare two sheets in Excel

    Another possibility is to get John Walkenbach's utility called PUP [Power Utility Pak] (just released v. 6 this week).

    J-Walk's site for PUP

    If you buy one of his books, it comes with the book, otherwise $39 US. There several hundred speciality utilities that are all time savers - one of them is this very issue. If you don't know who Walkenbach is, then you need to know who he is - one of the premier Excel specialists in the world. His books include:

    Excel Charts

    Excel Formulas

    Excel Power Programming with VBA

    I have all three handy on my desk and use/refer to them daily. PUP is the best utility I have found for Excel (and I have several).

    btw - I have no stake in J-Walk or his books/products. I am a satisfied customer.
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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