My worksheet has 1000+ names in alphabetical order. How can I put the names in
random order?

Thanks!

Steve

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

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

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

yes, intentionally. Useful in case you have to produce lots of
sample data e.g. for further analysis purposes.
Not the right when only unique values have to be randomized.
Maybe I misread the question in the first place, sorry.

Regards,

H.G. Lamy

"Tom Ogilvy" schrieb im Newsbeitrag
...
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