How to indentify duplicates in a "Self Populating" field?

S

Steven

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.
 
J

Jason Morin

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
 
S

Steven

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