I’m looking for a solution re comparing data elements from within common records on 2 separate Excel files. For example, if the same person with same record ID appears on two files, but the second file’s record has a different mailing address, how do we identify the variance between the 2 files?
Here’s an example:
File 1 records
ID1000 John Smith 12 Main St Topeka KS 62000
ID1001 Tommy Shaw 11 Johnson Way Omaha NE 72331
ID1002 Bob Barker 154 Edgewood Ln Billings MT 89002
File 2 records
ID1000 John Smith 12 Main St Topeka KS 62000
ID1001 Tommy Shaw 3445 Summerset Dr Omaha NE 72334
ID1002 Bob Barker 154 Edgewood Ln Billings MT 89002
How do we compare files in this example to identify that Tommy Shaw has a different address on File 2 vs File 1?
Does anyone have formula or tips to handle this type of data comparison?
Thank you in advance.
Here’s an example:
File 1 records
ID1000 John Smith 12 Main St Topeka KS 62000
ID1001 Tommy Shaw 11 Johnson Way Omaha NE 72331
ID1002 Bob Barker 154 Edgewood Ln Billings MT 89002
File 2 records
ID1000 John Smith 12 Main St Topeka KS 62000
ID1001 Tommy Shaw 3445 Summerset Dr Omaha NE 72334
ID1002 Bob Barker 154 Edgewood Ln Billings MT 89002
How do we compare files in this example to identify that Tommy Shaw has a different address on File 2 vs File 1?
Does anyone have formula or tips to handle this type of data comparison?
Thank you in advance.