Randomizing Lists

[WarofWinter]

Hi, new to the forums, I'm currently attempting to randomize a sample of 50 into smaller random sets of 10/15. While I could use random.org, I will be doing this 100 times and was hoping for a easier solution. Haven't used Calc in a while so unsure where to start, and haven't been able to find the answer else where.

[Lupp]

The usual way is to use a parallel column where each cell contains the formula

Code: Select all

=RAND()

and then to select a range containing the entries to randomize and the generated random numbers as well, and to sort it using the random numbers as the (first and only) key.

If the "randomness" of the software random generator meets your needs I cannot tell.

See also: viewtopic.php?f=75&t=58665.

[WarofWinter]

I'll try to explain my question, if I have a list of letters, a,b,c,d,e. I'm attempting to arrange the in a random order 100 times. Is that possible?

[Villeroy]

Yes, it is possible and Lupp pointed you to an excellent tutorial.