Re: random list in excel

All I can say is that if you have a column with =Rand()
You will get non-equal numbers (the odds of a repeting number are very low).
Replace the formula with PasteSpecial Value. Sort everything by that column
and you get a random ordered list.

There are many ways that you can do this in code, or manually.

--
steveB

Remove "AYN" from email to respond
"Lw" <Lw@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0CD6F698-2C1C-49B9-811B-6277442A7F9E@xxxxxxxxxxxxxxxx
>I have a list of 80 names that has to be randomly put in to an order where
> all the names are used only once. How do I do that


.