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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I compare two seperate spreadsheet files to identify diff 1
excel spreadsheet compare 3
Compare dates and unique identifier 1
Comparing two ranges of data and identify the common/like informat 2
Comparison Formula 2
Identify Duplicates in a List 1
Identifying new records 2
Comparing Two Spreadsheets 5

Back
Top