Match multiple columns in 2 spreadsheets

  • Thread starter Thread starter Ruthey
  • Start date Start date
R

Ruthey

Hi all excel wiz!

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!

All help/comments are very much appreciated!

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