I want to generate a random list each day of sums from a list I have created.
Can anyone help? Thanks

On Jan 10, 1:17 pm, TU340 wrote:
I want to generate a random list each day of sums from a list I have created.
Can anyone help? Thanks

What does your list look like?

Each sum is written in text based form in a cell and the sums are input in a
column 200 odd cells long. The sums are things like "4 x 5=" or "3/4 of 20=".
I just want to be able to randomly extract something like 40 of the cells a
day to produce a mental arithmetic worksheet.

"iliace" wrote:

On Jan 10, 1:17 pm, TU340 wrote:
I want to generate a random list each day of sums from a list I have created.
Can anyone help? Thanks

What does your list look like?

I assume you're looking for a random list - without replacement -,
meaning - no duplication within the random selection.

Place your datalist of text values in an out-of-the-way location, say Z1 to
Z200.

In Y1 enter the rand function:
=Rand()
And copy down to Y200.

Now, in A1, enter this formula:

=INDEX(Z$1:Z$200,RANK(Y1,Y$1:Y$200))

And copy down as many rows as you need.

You will generate a *new* random list with each hit of <F9.

With this type of formula, it might pay to place your sheet in "Manual Calc"
mode, so that you don't inadvertently refresh your list by accident.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"TU340" wrote in message
...
Each sum is written in text based form in a cell and the sums are input in a
column 200 odd cells long. The sums are things like "4 x 5=" or "3/4 of
20=".
I just want to be able to randomly extract something like 40 of the cells a
day to produce a mental arithmetic worksheet.

"iliace" wrote:

On Jan 10, 1:17 pm, TU340 wrote:
I want to generate a random list each day of sums from a list I have
created.
Can anyone help? Thanks

What does your list look like?