View Single Post
  #1   Report Post  
news.zen.co.uk
 
Posts: n/a
Default Returning one text value in a long list?

I have a long list of names and would like excel to automatically return
just one of each name. For example, a list of 500 names, 10 different names
appearing 50 times each. How could I get excel just to list those ten names?