Well doing it the way you had suggested... datafilteradvanced filter...

There are a total of 5 duplicate UPC Codes...

now, how to find them...

I know there are 5 duplicates, because of the amount of blank cells at the
bottom of the list... when compared side by side the other UPC Code Column,
the list I filtered, came up short by 5 cells...


--
Jeremy Himmelreich
Computer IT Manager
http://home.comcast.net/~jeremy1982
http://www.willitshoe.com


"Peo Sjoblom" wrote:

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?