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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

[Q] How to sort tabs in order of CodeName 2
Select random records by two conditions 1
selecting names in a list 3
random range of cells via cell names 3
Selecting from a randomized list 7
Worksheet Sort Order 2
how do I create a random list whilst keeping some entries fromrandomizing? 1
List out the "Find All" results list? 3

Back
Top