Assume the 2 source sheets to be compared are Sheet1 and Sheet2, with
supposedly identical data running in A2:C2 down
Use a 3rd sheet to check, ie in Sheet3:
In A2: =--(Sheet1!A2=Sheet2!A2)
Copy across to C2, fill down to cover the same extent as that in the 2
source sheets. Identical data will show up as 1's, non-identical data, ie the
discrepancies, as zeros.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Ruthey" wrote:
I have 2 spreadsheets that has the same data, but input by 2 different
people, so I'm trying to find out the discrepancies between the 2
spreadsheets.
if there are 3 columns in the spreadsheets: Plant Date QTY
How can I use excel to match the data in the 3 columns?
I have tried index,match,sumproduct, but no luck!