MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Compare two spread sheets and identify differences


Posted by Bill Ridder on January 17, 2001 10:01 AM

I have a spread sheet that lists document ID number, document date (date document is planned to be issued) and multiple other columns of document data. The original document list is modified and a new one created. I would like to compare the new list to the old list and have the new,deleted,and modified items identified in some manner.
1.
Any thoughts on how I could proceed?
2. Is there a way to extend the above to a general spread sheet to spread sheet comparison with differences identified such is done in Microsoft Word?
Thanking you in advance.
Bill


Posted by thomas venn on January 17, 2001 2:31 PM

try vlookup or index(...match(..)). essentially, if there is no exact match, you will get an error. the errors are you changes.

cheers,

- thomas