Compare spreadsheets

[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.

 

[Pete_UK]

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]

Yes, it does. I will investigate the match function. Thank you.

 

[Pete_UK]

You're welcome.

Pete

Yes, it does. I will investigate the match function. Thank you.






- Show quoted text -

 

[Smirnoff]

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.

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).

 

[Evgeny Grischenko]

Dear JS,
you can try to use this add-in - Compare Spreadsheets for Excel, it gives
out a resulting list with all the differences in the spreadsheets
http://www.office-excel.com/excel-addins/compare-spreadsheets.html

Evgeny