create a random list of names from a list of names in EXCEL

[Guest]

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.

 

[Biff]

See this:

http://mcgimpsey.com/excel/udfs/samplenoreplace.html

Biff

 

[Guest]

Thanks for that ;-)

See this:

http://mcgimpsey.com/excel/udfs/samplenoreplace.html

Biff