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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top