Excel Search Listings

C

chesjak

Hi

I am using Excel XP pro

I have a list of names or whatever in one column.

Is there any way I can do a search for all names that have been duplicated
and it throw up a list for me. The search facility seems to be a bit limited
for this task.

Regards
 
T

Teethless mama

select your range

Conditional Formatting

=COUNTIF($A$1:$A$100,$A1)>1

format any color you like (it will highlight all the duplicated)
 
Top