How do I display Random words in Excell

  Migwell 13 Nov 11
Locked
Answered

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

  VoG II 13 Nov 11
  Migwell 13 Nov 11

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.

  VoG II 14 Nov 11

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.

  Forum Editor 14 Nov 11

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

  VoG II 15 Nov 11

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)))

  lotvic 15 Nov 11

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))

  tonyq 14 Dec 11

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 ?

  VoG II 14 Dec 11

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.

  tonyq 14 Dec 11
Answer

Thank you VoG, will let him know.

Advertisement

This thread is now locked and can not be replied to.

Should I upgrade to Windows 10? 8 reasons why you should upgrade to Windows 10... and 2 why you…

We are being sold the ability to spend money we don't have. And we love it

IKinema aims to banish droopy shoulders and wonky spines in animated CG characters

How to use Apple Music in the UK: Complete guide to Apple Music's features

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message