Prev: Calculate number of days
Next: Creating a formula
From: overthehill lady on 23 Apr 2010 15:23
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.
From: Dave Peterson on 23 Apr 2010 15:29
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
From: Luke M on 23 Apr 2010 15:32
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" <overthehilllady(a)discussions.microsoft.com> wrote in
message news:4E5C7745-86CF-42EE-97B6-A76640CDDF4E(a)microsoft.com...
>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.


From: Teethless mama on 23 Apr 2010 16:02
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.
 | 
Pages: 1
Prev: Calculate number of days
Next: Creating a formula