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!
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!