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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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