This did the trick. Thank you so much for your help! I learn something new
everyday.

"Jason Morin" wrote:

With product ID numbers in column A, put this in an open
column in row 1, and fill down:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a database of information for the products I deal
with (i.e. Product
names, Product ID numbers, Product Pricing...). Using
the DGET function
formal, I can populate a list of products according to
the criteria used in
DGET. I was wondering is there a formula or way to
identify duplicate
entries within a field (i.e. - Product ID numbers).
Some products use the
same accessories and I want to limit the list of
accessories (or at least
identify the duplicates) so that I can isolate the
accessory one time without
having it listed several times. All I need is help
identifying duplicates
within the field/range and I can take it from there.
Thank you all for any
help you can give me.
.