A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Word lists



 
 
Thread Tools Display Modes
  #1  
Old April 23rd, 2010, 08:23 PM posted to microsoft.public.excel.worksheet.functions
overthehill lady
external usenet poster
 
Posts: 1
Default 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  
Old April 23rd, 2010, 08:29 PM posted to microsoft.public.excel.worksheet.functions
Dave Peterson
external usenet poster
 
Posts: 19,791
Default 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  
Old April 23rd, 2010, 08:32 PM posted to microsoft.public.excel.worksheet.functions
Luke M[_4_]
external usenet poster
 
Posts: 451
Default 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  
Old April 23rd, 2010, 09:02 PM posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
 
Posts: 3,722
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.