Excel Search Listings
 

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

Excel Search Listings
 

select your range

Conditional Formatting

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

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


"chesjak" wrote:

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