Displaying duplicate recrords from a Data List
 

Hi,

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

Thank you!

Craig

Displaying duplicate recrords from a Data List
 

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

--
Gary''s Student - gsnu200797


"Craig" wrote:

Hi,

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

Thank you!

Craig