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