MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Comparison


Posted by Adam Warner on June 11, 2001 12:16 PM

I need to compare two sheets and have any differences to these sheets placed on another spread sheet. We have large run lists that are in excel and customers tend to change a value here and there on us. It would save us a great deal of time if we could have any changes between the old version and the new version reported.

Any help will be appreciated. (highlighting changes wont work).

Thanks

Adam


Posted by Ben O. on June 11, 2001 12:23 PM

This may not be the ideal solution, but you could create a third sheet, enter this formula in A1, and autofill the formula all the way down and across:

=IF(Sheet1!A1<>Sheet2!A1,"","*")

It will compare just the value of each cell on Sheet1 to its corresponding cells on Sheet2. If the cells are different, it wll put an asterisk in the corresponding cell on Sheet3.

-Ben