Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I make BINGO boards using EXCEL?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I create multiple random bingo cards in excel? | Excel Worksheet Functions | |||
Boards Broken in Browsers | Excel Discussion (Misc queries) | |||
Create random number bingo cards with Excel | New Users to Excel | |||
how can I enter books of the bible into excel and print out bingo. | New Users to Excel | |||
Is there a way to animate cell(s) boards in Excel? | Excel Discussion (Misc queries) |