How do I randomly choose cells from a range to reproduce elsewhere

T

TU340

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

TU340

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.
 
R

RagDyeR

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!
=====================================================


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