You can use Advanced Filter to do this very quickly. Debra Dalgleish
shows how he

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

Hope this helps.

Pete

On Oct 21, 12:21*am, The Fru Fru
wrote:
I have started a book club and made an excel sheet for all of the details
including the books owner. *If a member has put on multiple books, their name
appears multiple times. *What i am trying to do is generate a list with
everyones name on it only once, from the long list of repeated names. *This
short list will then be linked to the drop down box, so that a new member to
the book club only has to enter their name once, then it appears in the drop
down list.