Word lists

  • Thread starter Thread starter overthehill lady
  • Start date Start date
O

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