G
Guest
How can I isolate the number of records where a field is duplicated i.e. we
have a barcode field in our stock DB where we have discovered there are some
duplicated barcodes.
We have tried to pull the data into a pivot table using the count function
of stock codes that carry the same barcode, but all we get is a count of 1
even though we know some of the barcodes are duplicated.
Does this make sense?
Anyway is there another way of using Excel to filter barcodes?
TIA
have a barcode field in our stock DB where we have discovered there are some
duplicated barcodes.
We have tried to pull the data into a pivot table using the count function
of stock codes that carry the same barcode, but all we get is a count of 1
even though we know some of the barcodes are duplicated.
Does this make sense?
Anyway is there another way of using Excel to filter barcodes?
TIA