How can I compare two seperate spreadsheet files to identify diff

  • Thread starter Thread starter Bob H
  • Start date Start date
B

Bob H

I have two seperate spreadsheet files I need to compare the two to identify
differences. Is there a way to do this.
 
On the face of it, one quick n easy way to compare cell-by-cell is to use a
3rd sheet
Assume the 2 source sheets to be compared are Sheet1 & Sheet2
In another new sheet,
Put in A1: =--(Sheet1!A1=Sheet2!A1)
Copy across/fill down as far as required to cover the corresponding used
range in the source sheets. 1's will indicate same values, 0's show where its
different
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 

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

VBA Excel partial cell compare to another cell 0
excel spreadsheet compare 3
compare two spreadsheets and identify records that have any change 2
Comparing Two Spreadsheets 5
Compare dates and unique identifier 1
Split screen 4
Compare Data in two Separate Worksheets 3
Comparing two ranges of data and identify the common/like informat 2

Back
Top