Word lists

[overthehill lady]

I am a teacher and I use vocabulary lists. I would like to know if there is a
way to mix up a list of words so that they do not appear in the same order
all the time.

 

[Dave Peterson]

If the list is a single column (say A1:A10), you can put a formula in the
adjacent cells (say B1:B10):

Put this in B1:
=rand()
and drag down to B10.

then select A1:B10 and sort this range by column B.

If you want to mix them up again, just recalculate to get new random numbers and
sort once more.

 

[Luke M]

Certainly. Let's say your list is in A1:A100. In B1, input:
=RAND()
Copy this down to B100. Then, in C1, input:
=INDEX(A$1:A$100,RANK(B1,B$1:B$100))
Copy down to C100

You now have a randomized list of words. To get a new list, simpyl hit F9
(to relcalculate sheet).

 

[Teethless mama]

Assuming your data A1:A10

In B1: =RAND()
copy down to B10

In C1: =INDEX($A$1:$A$10,RANK(B1,$B$1:$B$10))
copy down to C10

Press F9 to randomize the list of words.