Filter Query

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi

I have a worksheet that has approximately 4000 serial numbers in column A.
Is it possible to filter it somehow that would only show the duplicated
numbers?

TIA
Steve
 
You could use a helper column and Autofilter like this:

org filt
1 unique
2 duplicate
3 duplicate
4 duplicate
2 duplicate
5 unique
6 unique
3 duplicate
7 unique
8 unique
4 duplicate

Formula in col "filt" and down is:
=IF(COUNTIF(A:A,"="&A2)=1,"unique","duplicate")

Regards

Hans
 
Back
Top