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.:confused:


--
jtreme
------------------------------------------------------------------------
jtreme's Profile: http://www.excelforum.com/member.php...o&userid=28842
View this thread: http://www.excelforum.com/showthread...hreadid=485907

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.:confused:


--
jtreme
------------------------------------------------------------------------
jtreme's Profile: http://www.excelforum.com/member.php...o&userid=28842
View this thread: http://www.excelforum.com/showthread...hreadid=485907