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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find duplicates in address register 2
How to copy rows from a sheet with duplicates in a column to a wor 1
Duplicates in Conditional Formatting 5
Navigating to Duplicates 2
Not including duplicates in a count 1
is there a simple formula that will remove all duplicates in a simple list 1
Finding Duplicates in a Column (Without Sorting) 3
Generation of Queries to identify duplicates records in Access Dat 2

Top