I need help making bingo cards!!! :)

[Tricia LeAnn]

I am hostessing a baby shower this weekend, and I want to make "baby bingo"
cards for the guests to play. I'm not exactly sure how to set it up....
Please give me some ideas?!?

 

[akphidelt]

You can try this... format the cells in the normal 5 by 5 bingo sheet (or
whatever you want). Change there sizes, colors, or whatever to make them cute
for your baby shower... haha

But then in the top left cell type the formula

=RAND()*65

Change the 65 to the max number you want allowed on the bingo sheet. If its
40 then do Rand()*40

Copy that cell to all the other cells on the bingo sheet. Create a printable
range and then print it.

Then go in to the upper left cell again, make sure you click in to the
actual formula and click enter... this will recalculate all the cells again
creating a new random bingo card.

You can even go to kinkos to get thicker paper or something, but just keep
creating new sets of random numbers and printing them off.

 

[T. Valko]

There is a sample file here:

http://contextures.com/excelfiles.html#Function

Look for FN0003 - Bingo Cards

 

[T. Valko]

mark

--
Biff
Microsoft Excel MVP

There is a sample file here:

http://contextures.com/excelfiles.html#Function

Look for FN0003 - Bingo Cards

 

[Bill Sharpe]

You can try this... format the cells in the normal 5 by 5 bingo sheet (or
whatever you want). Change there sizes, colors, or whatever to make them cute
for your baby shower... haha

But then in the top left cell type the formula

=RAND()*65

Change the 65 to the max number you want allowed on the bingo sheet. If its
40 then do Rand()*40

Copy that cell to all the other cells on the bingo sheet. Create a printable
range and then print it.

Then go in to the upper left cell again, make sure you click in to the
actual formula and click enter... this will recalculate all the cells again
creating a new random bingo card.

You can even go to kinkos to get thicker paper or something, but just keep
creating new sets of random numbers and printing them off.

Several problems here:
Standard Bingo numbers go from 1 to 75.
You may get repeat numbers.
You won't get the right numbers. The "B" column should have 1 to 15, "I"
should have 16 to 30, etc.
You need to be sure the resulting numbers are integers.
Try the contextures site mentioned in another reply.

Or perhaps you're looking for something like this:
http://www.babbee.com/baby_bingo/

Bill