Randomize a list of names

S

Steve

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

Thanks!

Steve
 
T

Tom Ogilvy

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
 
H

hglamy

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
 
H

hglamy

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
 
Top