compare two spreadsheets and identify records that have any change

B

brenped

compare two spreadsheets and identify records that have any changes.
For example comparing two spreadsheets with the same specific employee
information such as first, middle and last name; employee number etc. and
only identifying records that have changes.
 
G

Gary Brown

How about doing a vlookup from one worksheet to the other. If the value is
N/A, you know the record has changed on the other worksheet.
HTH,
 
P

Pimulo Bradfeet

Use the = exact formula for comparing. You can then filter the colums for
all the false information which will tell which cells have been changed. I
sometimes also use =index and =match in order to find data matches.
 
Top