I would like to use the spreadsheet to repeated randomize the order of a set list. Can you help?

eggs · February 7, 2020, 4:59pm

I am trying to make number facts worksheets for school kids that include all the basic facts per operation on each sheet in random order. I can use the random number generator to make sheets with random problems, but I can’t figure out how to randomize the order of a set list of problems. Please help.

eggs · February 7, 2020, 5:46pm

Basically, I just want to UNSORT, randomly.

eggs · February 7, 2020, 6:06pm

shuffle…

anon73440385 · February 7, 2020, 6:55pm

Introduce a column with random integers and sort according that column

Lupp · February 7, 2020, 10:59pm

Why random integers? Any value may repeat.

anon73440385 · February 7, 2020, 11:18pm

Of course you are right … forget about the crude idea.

Lupp · February 7, 2020, 11:27pm

To widen the horizon of the question a bit: [Tutorial] Randomization in Calc (View topic) • Apache OpenOffice Community Forum

keme · February 8, 2020, 8:58pm

You can create a jumbled set in three simple steps:

Use the RAND() function to generate individual “score” to each problem.
Use the RANK() function to generate sequence numbers based on those scores.
Use VLOOKUP() to extract problem descriptions in the generated sequence

See the attached file for a small sample.