Excel 2010 spreadsheet comparison

Posted on 2011-10-25
Medium Priority
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
  • 3
  • 2
LVL 10

Expert Comment

ID: 37025439
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

ID: 37025534
I can do the countif but not the vlookup.
LVL 10

Accepted Solution

etech0 earned 2000 total points
ID: 37025557
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

ID: 37025614
That worked!  Thanks for the quick response.
LVL 10

Expert Comment

ID: 37025621
Glad to help!

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

864 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