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

How To Compare Two Csv Files Mainly Two Columns Containing Time 0
WordPad blocked content 2
Add additional information to excel form after original data entry 0
How to automate update on weekly reports spreadsheet 0
Office JS api to handle redo/undo , delete event for content control class 0
Identifying duplicates between 2 spreadsheets 0
Create a dynamic master file 1
Inconsistent formatting of section numbers 0

Top