You can use a help column and tag them with a formula

Assume they are in A2:A1000, insert a new column B and in
B2 put

=IF(COUNTIF($A$2:A2,A2)1,"Duplicate","")

copy down, or if you just want to remove dupluicates you can apply
datafilteradvanced filter, select copy to another location and unique
records only


Regards,

Peo Sjoblom


JeremyH1982 wrote:
My question is how?

How can I find out if there are duplicates in the UPC Code Column?