M
mark
It was just brought to my attention that something I wrote a couple of years
ago is duplicating data.
It uses Data-Consolidate, in VB.
A simple exampe would be this:
cell A1: ItemNumber
cell B1: Amount
cell A2: 61*80*C51*022
cell B2: 1
cell A3: 61-80-C51-022
cell B3: 1
If you use menu items Data-Consolidate on that, it gets a total of 3, not 2.
It's taking the item in cell A3 as a match to both itself, and to the item
in A2. So, it's doing a wildcard sum.
I can fix this by editing my code to use a Pivot Table to summarize the data
instead.
This post is more just a warning to anyone else who might have ever done
such a thing unaware.
ago is duplicating data.
It uses Data-Consolidate, in VB.
A simple exampe would be this:
cell A1: ItemNumber
cell B1: Amount
cell A2: 61*80*C51*022
cell B2: 1
cell A3: 61-80-C51-022
cell B3: 1
If you use menu items Data-Consolidate on that, it gets a total of 3, not 2.
It's taking the item in cell A3 as a match to both itself, and to the item
in A2. So, it's doing a wildcard sum.
I can fix this by editing my code to use a Pivot Table to summarize the data
instead.
This post is more just a warning to anyone else who might have ever done
such a thing unaware.