How do I compare the difference in two spreadsheets?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
__
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing two spreadsheets 2
Excel Comparing two columns 1
Comparison Formula 2
Function needed? 1
comparing columns in two spreadsheets 1
How do i compare two different files 2
Compare two lists 1
comparing two worksheets 1

Back
Top