Comparing work books

M

Mag\(\)\(\)

Hey all,
I have 2 spreadsheets supplied by a customer who tells me they are
the same.

The have around 8000 lines in each and have information in columns A through
to H.

What is the best way to compare these 2 worksheets?
The columns I am interested in the change would be A through to D only. The
rest of the column info is not really important.

Hope someone can help me.

TiA

mag()()
 
J

JamesG

If the spreasheets are supposed to have all the all the same values i
the same locations, you can do the following. Let's say the data ar
on two worksheets called 'Sheet1' and 'Sheet2'. On a separat
worksheet, just subtract the values in similar cells from each other.
For example, on a blank worksheet, 'Sheet3', type the following int
cell A1: =Sheet1!A1-Sheet2!A1. If the two numbers are the same, th
value will be zero. Copy and paste this formula into all the cell
where that you are comparing between sheets. Any non-zero value is
difference. You can tell Excel to SUM all the comparison cells an
will quickly be able to see if there were any differences
 
L

Lorne H

Hello,

You may wish to try a MATCH function. I use it for comparing large
lists (2,000 to 30,000 lines) of customer information. It will look at
one list and tell you (true/ false) if the lines of the other list
match. It will not tell you if the sequence is different.

Lorne.
 
Top