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

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.

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

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.

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

Thanks for that ;-)

"Biff" wrote:

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.