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

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

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

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