Compare spreadsheets

  • Thread starter Thread starter JS
  • Start date Start date
J

JS

What is the best way in EXCEL to compare two spreadsheets so I can determine
any differences in content?

Each spreadsheet would have the same # of columns and the same # of rows.
The only difference would be the data within some of the cells.

Thanks in advance.
 
You would need a column in both sheets which has some unique
identifier (eg person-number, or stock-number), then you could use
VLOOKUP from one sheet to the other to see if that record was present,
and to compare values from one field to another. You could also use an
INDEX/MATCH combination to do the same job.

Hope this helps.

Pete
 
JS said:
What is the best way in EXCEL to compare two spreadsheets so I can
determine
any differences in content?

Each spreadsheet would have the same # of columns and the same # of
rows.
The only difference would be the data within some of the cells.

Thanks in advance.
Click to expand...

Open both spreadsheets. Under the Window menu choose Compare side by
side.

Excel Help will give further details if you just type in Compare (first
result).
 
Back
Top