One way would be to create a copy using the Advanced Filter. See link

http://www.contextures.com/xladvfilter01.html#FilterUR


"r.kordahi" wrote:

i have a list of names as
robert
paul
martin
edwin
robert
paul
martin
edwin
marc
rony
i need a list how will display the names listed and only once the repeated
names or