Contact Forum Editor

Send an email to our Forum Editor:

PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom

It's free to register, to post a question or to start / join a discussion

View Forum Rules | Contact Forum Editor

 

How do I display Random words in Excell

Migwell
Resolved

Likes # 0

Posted November 13, 2011 at 5:35PM

To help my granson learn to read, I have put all his word's from those he has been given at school into a spreadsheet in excell. My plan is to be able to display one word at a time on the computer monitor and if he get's it right he then needs to press the enter button and get the next RANDOM word from the list.

Can anyone tell me how to do this please, using Excell 2010

Thanks Migwell

Like this post
VoG II

Likes # 0

Posted November 13, 2011 at 6:12PM

Like this post
Migwell

Likes # 0

Posted November 13, 2011 at 10:16PM

Thanks VoG that has started to work but at this moment I have 90 words spread over A 1 to F15 and every few days more words will be added. I need to go further, what changes do you recomend.

Like this post
VoG II

Likes # 0

Posted November 14, 2011 at 7:24AM

I would have put all the words in column A. Then you just need to change the 10 in the formula to the number of used rows.

Like this post
Forum Editor

Likes # 0

Posted November 14, 2011 at 8:32AM

I've locked your duplicate thread, now that you're getting the best possible advice in this one.

Like this post
VoG II

Likes # 0

Posted November 15, 2011 at 3:55PM

With the words in column A only, this formula will adjust automatically for the number of used rows

=INDEX(Sheet1!A:A,RANDBETWEEN(1,COUNTA(Sheet1!A:A)))

Like this post
lotvic

Likes # 0

Posted November 15, 2011 at 8:52PM

I think this works for displaying random words from columns A B C with words in each column up to row number 10

=INDEX(Sheet1!A:C,RANDBETWEEN(1,COUNTA(Sheet1!A1:A10)),RANDBETWEEN(1,3))

or if you have column headings in row 1 and word list in each column starts in row 2 down to row 11

=INDEX(Sheet1!A:C,RANDBETWEEN(1,COUNTA(Sheet1!A2:A11)),RANDBETWEEN(1,3))

Like this post
tonyq

Likes # 0

Posted December 14, 2011 at 6:23PM

Sorry for digging up an old post.Thought it better than starting a new one on the same subject Through your help with answering Migwells question,I have used the above in my version of 2007 Excel O.K. but my son as been unable to get it to work in Excel 2003.So my question is,Should it work in Excel 2003 ?

Like this post
VoG II

Likes # 0

Posted December 14, 2011 at 6:27PM

Yes but in Excel 2003 it requires that the Analysis ToolPak is installed. Go to Tools > Add-Ins, tick Analysis ToolPak and click OK. The formula should then work.

Like this post
tonyq

Likes # 0

Posted December 14, 2011 at 6:37PM

Thank you VoG, will let him know.

Like this post  

Reply to this topic

This thread has been locked.



Check out PC Advisor's other tech forums

Send to a friend

Email this article to a friend or colleague:

PLEASE NOTE: Your name is used only to let the recipient know who sent the story. Both your name and the recipient's name and address will not be used for any other purpose.