Comparing data between two excel sheets
Solved/Closed
Hello,
I have two excel sheets with the same columns. Essentially Name, Email, Phone. One sheet is the 'original" data and the other is the "updated" data which may contain additions or deletions of names, and/or changes in email address, phone, etc.
How do I generate a list of "changes" - essentially differences in sheet 2 compared to sheet 1. For example, A list of changed emails by name? A list of names on sheet 2 that do not appear on sheet 1?
Thanks!
I have two excel sheets with the same columns. Essentially Name, Email, Phone. One sheet is the 'original" data and the other is the "updated" data which may contain additions or deletions of names, and/or changes in email address, phone, etc.
How do I generate a list of "changes" - essentially differences in sheet 2 compared to sheet 1. For example, A list of changed emails by name? A list of names on sheet 2 that do not appear on sheet 1?
Thanks!
Related:
- Compare two excel sheets for differences
- Excel mod apk for pc - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
- Sheets right to left - Guide
- Mark sheet in excel - Guide
- Excel compare two sheets - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 20, 2010 at 06:03 AM
Dec 20, 2010 at 06:03 AM
suppose sheet 1 is
name email phone
a
d
g
sheet 2 is
name email phone
A
S
D
F
G
H
J
K
in sheet 2 in D2 copy this formula
=VLOOKUP(A2,Sheet1!$A$2:$C$101,1,0)
copy the formula in D2 down. wherever the data is not available in sheet will show #N/A
You can modify this solution to suit your needs
name email phone
a
d
g
sheet 2 is
name email phone
A
S
D
F
G
H
J
K
in sheet 2 in D2 copy this formula
=VLOOKUP(A2,Sheet1!$A$2:$C$101,1,0)
copy the formula in D2 down. wherever the data is not available in sheet will show #N/A
You can modify this solution to suit your needs
Dec 13, 2012 at 05:46 PM
Mar 19, 2014 at 05:14 AM
Mar 31, 2014 at 10:39 PM
Jun 10, 2014 at 02:52 PM
Dec 22, 2014 at 10:06 AM