streamlining a list

Hi all,
Does anyone know if the following is possible and if so how to it?

I have a list of names 200+ but some names are repeated up to 20 times. Is there any function that will produce a list from these names but list each name just once?

Thanks.

or try an add-in
asap utilities has a duplicate find/highlight/delete function
http://www.asap-utilities.com/

select column
then from the asap menur select columnss/rows
then select conditional , column/row select hide or delete
from search options drop down select
duplicate values
leave handle rows or columns on rows
select delete from what to do with found rows/columns
select start