Select the column with the codes and go menu Data Filter Advanced
filter, choose "unique items only".

HTH. Best wishes Harald

"Jonathan" skrev i melding
...
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