How do I compare the difference in two spreadsheets?

D

Daysi

I have two separate excel worksheets i need to find out if there is a way to
compare between the two to see the ones that are missing from one another
 
R

Richard Buttrey

I have two separate excel worksheets i need to find out if there is a way to
compare between the two to see the ones that are missing from one another
Click to expand...


Assuming the layout is the same, and you're trying to test whether all
cells in one sheet are the same as the same cell range in the other
sheet, then create a third worksheet and enter in A1

=IF(ISERROR(MATCH(Sheet2!A1,Sheet1!A1,FALSE)),"Different","Same")

Copy as far as required.

HTH. If not please re-post.

Richard Buttrey
__
 
Top