#1
|
|||
|
|||
Count Duplicate Values without a specific Unique Value
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!!! |
#2
|
|||
|
|||
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 | |
Display Modes | |
|
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 |