Displaying duplicate recrords from a Data List

C

Craig

Hi,

Is there a way for Excel 03 or 07 to quickly scan a data list and display
only duplicate records?

Thank you!

Craig
 
G

Gary''s Student

Say we have in A1 thru A11:

NAMES
james
james
mike
mike
david
george
nigel
trevor
william
albert

and we want to see only duplicated names. In B1 enter:
TAG
In B2 enter:
=COUNTIF(A:A,A2) and copy down. We see:

NAMES TAG
james 2
james 2
mike 2
mike 2
david 1
george 1
nigel 1
trevor 1
william 1
albert 1

Click on B1 and:

Data > Filter > AutoFilter > Custom... > Is greater than 1
and we now see:

NAMES TAG
james 2
james 2
mike 2
mike 2
 
Top