Check out this web site of Chip Pearson's.

Scroll down to the "D's", and see all the pages pertaining to duplicates.

http://www.cpearson.com/excel/topic.htm
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Courtneyf04" wrote in message
...
I need a formula that tells me if there is a duplicate within the same
column. I have no idea how to go about this. I am wanting to enter in
Product ID numbers and if there is a duplciate I need to be warned. I
would
appreciate any help anyone can give - Thanks!