|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
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.
|