Randomize a list of names

[Steve]

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

Thanks!

Steve

 

[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

 

[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

 

[Tom Ogilvy]

that could result in duplicates.

Regards,
Tom Ogilvy

 

[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