ExcelBanter - How can I make BINGO boards using EXCEL?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I make BINGO boards using EXCEL? (https://www.excelbanter.com/excel-worksheet-functions/193448-how-can-i-make-bingo-boards-using-excel.html)

How can I make BINGO boards using EXCEL?

It depends on your number selection - if you use 1 to 68, then you can:

Enter the numbers 1 to 68 in cells B9:B76 (you can enter a 1 into B9, 2 into B10, select both cells,
then grab the fill handle and drag down)
Enter the formula

=RAND()

into cells A9:A76

In cells A1:E1, enter B I N G O

In cell B2, enter this formula

=VLOOKUP(LARGE($A$9:$A$76,(ROW()-2)*5+COLUMN()),$A$9:$B$76,2,FALSE)

then copy to B2:E6.

Enter "Free Cell" into C4.

Format the cells A1:E6 to look the way you want, and set that as your print area.

Press F9 to recalc (you will get new numbers), and then print to get a new card. Repeat as many
times as you need.

HTH,
Bernie
MS Excel MVP

"Nelson0902" wrote in message
...

How can I make BINGO boards using EXCEL?

Bernie Deitrick wrote:
It depends on your number selection - if you use 1 to 68, then you can:

Enter the numbers 1 to 68 in cells B9:B76 (you can enter a 1 into B9, 2 into B10, select both cells,
then grab the fill handle and drag down)
Enter the formula

=RAND()

into cells A9:A76

In cells A1:E1, enter B I N G O

In cell B2, enter this formula

=VLOOKUP(LARGE($A$9:$A$76,(ROW()-2)*5+COLUMN()),$A$9:$B$76,2,FALSE)

then copy to B2:E6.

Enter "Free Cell" into C4.

Format the cells A1:E6 to look the way you want, and set that as your print area.

Press F9 to recalc (you will get new numbers), and then print to get a new card. Repeat as many
times as you need.

HTH,
Bernie
MS Excel MVP

"Nelson0902" wrote in message
...

According to Wikipedia:

The highest number used is 75. The printed numbers on the card correspond to the
following arrangement: 1 to 15 in the B column; 16 to 30 in the I column; 31 to
45 in the N column; 46 to 60 in the G column and 61 to 75 in the O column.

So, I think you need to copy column A and B down to row 83 and then A2:E6 should be:

=VLOOKUP(LARGE(INDIRECT("$A$"&(COLUMN()-1)*15+9&":$A$"&(COLUMN()-1)*15+23),ROW()-1),INDIRECT("$A$"&(COLUMN()-1)*15+9&":$B$"&(COLUMN()-1)*15+23),2,FALSE)