B
Bernie Deitrick
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
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