Jessica,

I've written a "Bible Bingo" workbook that creates bingo
cards with the names of the books in the Bible.
It uses VBA programming code not formulas.
The code module is unlocked and viewable.

If you want a copy, I'll be glad to send it to you.
Send me a request via email (remove XXX from my email address).

Jim Cone
San Francisco, USA
XX


"sixpence668"

wrote in message

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