Find Missing Records

C

Chirag Dedhia

I searched enough on this topic but couldn't find anything that i could
put to use. Hence this query to you all.

I have two excel sheets.
Both Sheets have two columns (Name, Email Address)
Now i need to find out if there is any record(row) missing in the first
sheet by checking the second sheet, such that i can create a third
sheet with all the missing records(rows).

Any help or macros that you guys have used earlier, would be of great
help to me.

Regards,
Chirag Dedhia
 
G

GerryGerry

Try using a Vlookup on the second sheet using the first sheet as the table.
Then filter all the #N/A and copy to the third sheet.
 
D

Dave Peterson

Can you use the email addresses to look for matches?

If yes, then you can add a column of formulas to sheet2 that returns true or
false depending on if that email address appears in sheet1.

Say the email addresses are in column C of both sheets.

Insert a new column D in sheet2 and put this formula in D1:
=isnumber(match(c1,sheet1!c:c,0))
and drag down.

The cells that are true show that the email address appears in Sheet1. The
cells with False don't appear in sheet1.

You could filter by this column.
Show the Falses
and copy those visible rows to a new sheet.
 
Top