Match multiple columns in 2 spreadsheets
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! |
Match multiple columns in 2 spreadsheets
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! |
All times are GMT +1. The time now is 06:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com