compare two spreadsheets and identify records that have any change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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,
 
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.
 
Back
Top