Excel 2010 spreadsheet comparison

Posted on 2011-10-25
Last Modified: 2012-05-12
I have two spreadsheets.  I want to compare the spreadsheets and identified all names that are in spreadsheet one and not in spreadsheet two.  What is the best way to do this?
Question by:razorbackfan
    LVL 10

    Expert Comment

    add a column in spreadsheet 1 with a vlookup, anything with an error is not in spreadsheet 2. Alternatively, you can use countif, and anything that returns a 0 is not in spreadsheet 2
    Do you know how to create a vlookup or a countif?

    Author Comment

    I can do the countif but not the vlookup.
    LVL 10

    Accepted Solution

    So do a countif in the first spreadsheet, in a column. Have it look at the name in that row of the spreadsheet, and count the occurrences of it in the second spreadsheet. All the zeros that come up are not in the second sheet, and you can sort it by that column if you wish.

    Author Closing Comment

    That worked!  Thanks for the quick response.
    LVL 10

    Expert Comment

    Glad to help!

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now