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.