See this:
http://mcgimpsey.com/excel/udfs/samplenoreplace.html
Biff
"Givvie" wrote in message
...
I have listed some names in a coloum in Microsft Excel 2000 which I want to
be able to randomly list those names in another coloum (without them
repeating themselves in the "new" coloum). Is there a formula I can use?
I have tried to use random but seem only to be able to get numbers.