Randomize a list of names

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

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
 
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
 
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
 
Back
Top