Count Duplicate Values without a specific Unique Value

Brittni · #1 02-01-2017, 04:23 PM

I am looking for a formula that will go through Column A and identify if there are duplicate Barcodes entered and return these in Column D. I will also need it to identify the duplicate value but also return the error code into Column E.

I have attached an example.

thank you!!!

jeffreybrown · #2 02-01-2017, 06:22 PM

The easiest method, place in C2 and copy down...

=COUNTIF($A$2:$A$19,A2)

...now filter column C by anything greater than 1

Copy and paste

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Compare & remove both sets of duplicate values	mummy	Excel	1	03-28-2016 02:59 AM
Count unique values that match 2 or more criteria	caeiro01	Excel	1	10-25-2015 02:34 AM
Create a list that contains duplicate and unique names without blanks	Iced42	Excel	1	06-30-2015 04:50 PM
Macro to Delete Duplicate Rows and Retain Unique Value	expert4knowledge	Excel Programming	1	02-17-2014 08:02 PM
Display unique values and count the number of child items	vthomeschoolmom	Excel	2	07-25-2013 06:17 AM