ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Match multiple columns in 2 spreadsheets (https://www.excelbanter.com/excel-discussion-misc-queries/235187-match-multiple-columns-2-spreadsheets.html)

Ruthey

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!



Max

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