How can I compare two seperate spreadsheet files to identify diff

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.
 
M

Max

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
Comparison Formula 2
Function needed? 1
How to compare & then sum/list differences between spreadsheets? 1
Compare two different spreadsheet 1
Split screen 4
compare all data in one worksheet to another 1
Compare multiple cells and highlight differences 5

Top