Excel Search Listings

[Guest]

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

 

[Guest]

select your range

Conditional Formatting

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

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