that could result in duplicates.

Regards,
Tom Ogilvy


hglamy wrote in message
...
having a named range (e.g. "Politicians") with the names of politicians in
one column,
you could use this formular to randomize that list:

=INDEX(Politicians;INT(RAND()*(ROWS(Politicians))+ 1);1)

Copy that formular down, and you have ample randomized names of
politicians,
ready to be re-arranged by pressing F9.

Regards,

H.G. Lamy



"Tom Ogilvy" schrieb im Newsbeitrag
...
Next to the names, put in the formula

=rand()

then drag fill down the column. Sort all the data with this column as
the
sort key.

Regards,
Tom Ogilvy


Steve wrote in message
thlink.net...
My worksheet has 1000+ names in alphabetical order. How can I put the
names in
random order?

Thanks!

Steve