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

  • Thread starter Thread starter gillman54
  • Start date Start date
G

gillman54

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
 
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
 
Back
Top