Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Multiple Columns | Excel Worksheet Functions | |||
Match Data in Multiple Columns | Excel Discussion (Misc queries) | |||
Copy the same 2 columns from multiple spreadsheets into one new sh | Excel Discussion (Misc queries) | |||
Index/Match from multiple columns | Excel Worksheet Functions | |||
I need to match multiple columns before returning a value | Excel Discussion (Misc queries) |