How do I identify duplicated numbers in a large range of cells
 

I have a large range (column) of cells (3567) which contain Alpha numerical
i.d codes, I want to indentify cells where i.d codes are duplicated

How do I identify duplicated numbers in a large range of cells
 

Assume source data in A2 down
Put in B2: =IF(COUNTIF(A$2:A2,A2)1,"dup","")
Copy B2 down to the last row of data in col A to flag duplicates as "dup".
You can apply autofilter on col B, choose: dup to retrieve all at one go
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"gillman54" wrote:
I have a large range (column) of cells (3567) which contain Alpha numerical
i.d codes, I want to indentify cells where i.d codes are duplicated

How do I identify duplicated numbers in a large range of cells
 

Have a look at the video named "Using vlookup to Match Lists" over he
http://www.free-training-tutorial.co...n-vlookup.html


Or the video named: "Finding duplicate values or unique values with
conditional formatting" over he
http://www.free-training-tutorial.co...ormatting.html




"gillman54" wrote:

I have a large range (column) of cells (3567) which contain Alpha numerical
i.d codes, I want to indentify cells where i.d codes are duplicated