Paul B Wrote:
See if this will get you started, download bingo cards, almost at the
bottom
of the page

http://www.contextures.com/excelfiles.html
--
Paul B


I'm also looking to create some Bingo crads, and this file has been a
huge help! I've entered all of my words into the second sheet, and
it's creating one perfectly randomized Bingo card! Unfortunately, I
can't get it to produce _more_ than one. Even though the formulas are
the same as the ones in the sample file, all I get on the additional
cards is #NUM! for the results. As an example:

Here's the code for the first column on the original card -

=INDEX(Sheet2!$A$1:$A$9,MATCH(LARGE(Sheet2!$B$1:$B $9,ROW()-1),Sheet2!$B$1:$B$9,0))

Here's the code for the same column on the second card -

=INDEX(Sheet2!$A$1:$A$9,MATCH(LARGE(Sheet2!$B$1:$B $9,ROW()-3),Sheet2!$B$1:$B$9,0))

Any ideas why this doesn't give me any result??

Thanks in advance for the help!
Jessica


--
sixpence668
------------------------------------------------------------------------
sixpence668's Profile: http://www.excelforum.com/member.php...o&userid=25472
View this thread: http://www.excelforum.com/showthread...hreadid=328525