I actually should have made myself more clear... sorry,

the UPC Codes in question are 12 digits in length... so many of them will
contain the actual #1 in it...

I want to know how to find if there is another 717922031458 in another cell...

But I don't want to go to find, and type in 717922031458, and then type in
every other UPC Code we have on file... just to make sure it's not someplace
else in the system...


Hope that's more clear... Thanks though.

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


"Dave F" wrote:

Someone may have a more elegant method, but this works for me.

Assume the UPC codes are in range A2:A100 and A1 is a column heading.

In B2 enter the formula =IF(A2=A1,1,"") and fill down.

Wherever there is a 1 in column B you have a duplicate UPC code.

Dave
--
Brevity is the soul of wit.


"JeremyH1982" wrote:

My question is how?

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


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