If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|