How do I display Random words in Excell

  Migwell 13 Nov 11
Locked

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

Say your words are in Sheet1 cells A1 to A10. In Sheet2 Enter the formula

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

This will display a random word. To change the word press F9.

This will include repetition (not a bad thing when learning). To display words without repetition would, I think, require VBA.

Advertisement

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

Windows 10 Home vs Windows 10 Pro comparison: Here are the extra features you get in the Pro version

Why Formula-e needs to go faster

How Instagram spots trends

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