CCkfm2000
10-15-2008, 10:01 AM
Hi all,
Please see attached file.
I?m trying to compare some data from 2 different sources.
Both sets of data are imported into different sheets ?SAP? & ?WMS?
In ?checker? sheet columns D to H is a pivot table getting the data from ?WMS?.
I?ve got most of the formulas working in ?checker? sheet using sumproduct in columns I to J getting the data from ?SAP?
As you can see I?ve got some data missing in columns I to J which I?ve highlighted.
For life of me I can?t workout why it?s missing the data off.
Any help will be much appreciated.
Thanks again.
Please see attached file.
I?m trying to compare some data from 2 different sources.
Both sets of data are imported into different sheets ?SAP? & ?WMS?
In ?checker? sheet columns D to H is a pivot table getting the data from ?WMS?.
I?ve got most of the formulas working in ?checker? sheet using sumproduct in columns I to J getting the data from ?SAP?
As you can see I?ve got some data missing in columns I to J which I?ve highlighted.
For life of me I can?t workout why it?s missing the data off.
Any help will be much appreciated.
Thanks again.