Solved

Posted on 2011-10-25
Medium Priority
312 Views
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?
Sample-1.xlsx
Sample-2.xlsx
0
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?
0

Author Comment

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

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.
0

Author Closing Comment

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

LVL 10

Expert Comment

ID: 37025621
0

## Featured Post

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…
###### Suggested Courses
Course of the Month16 days, 12 hours left to enroll