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
 
Back
Top