| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with random inputs
I am a teacher and trying to make a bingo card with Excel. I am trying to make a list of scientific elements and let the computer randomly input them into the 5x5 card I have set up in Excel.  -- jtreme ------------------------------------------------------------------------ jtreme's Profile: http://www.excelforum.com/member.php...o&userid=28842 View this thread: http://www.excelforum.com/showthread...hreadid=485907 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problem with random inputs
list the scientific elements in a single column. In the next column enter
=RAND() and copy down. Sort by the second column; this will put the first column in random order. Fill as many cards as you like with the randomized list. -- Gary's Student "jtreme" wrote: I am a teacher and trying to make a bingo card with Excel. I am trying to make a list of scientific elements and let the computer randomly input them into the 5x5 card I have set up in Excel. -- jtreme ------------------------------------------------------------------------ jtreme's Profile: http://www.excelforum.com/member.php...o&userid=28842 View this thread: http://www.excelforum.com/showthread...hreadid=485907 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to keep random number from changing using RANDBETWEEN? | Excel Worksheet Functions | |||
| Date & Time problem | Excel Worksheet Functions | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| problem office assistant | Excel Discussion (Misc queries) | |||
Linear Mode
