Word lists
 

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.

Word lists
 

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.

overthehill lady wrote:

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

Word lists
 

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).
--
Best Regards,

Luke M
"overthehill lady" wrote in
message ...
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.

Word lists
 

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.


"overthehill lady" wrote:

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.