Bingo

[Guest]

I am trying to set up something to create bingo cards with words in them. I
have my calling sheet created. I typed in the words I wanted on the call
sheet. Now I would like to randomly populate the Bingo cards from the call
sheet. Is this possible with text? I would like to populate the cards in
column A sheet 1, with text that is in column A sheet 2. Then column 2 sheet
1 with column 2 sheet2. I hope this makes sense.

 

[Dave Peterson]

Create a new workbook.

On sheet1:
put this in A1:A100:
=rand()
put your phrases in B1:B100

Then in Sheet2
Put this in A1:
=INDEX(Sheet1!$B$1:$B$100,
MATCH(LARGE(Sheet1!$A$1:$A$100,((ROW()-1)*5+(COLUMN()-1)+1)),
Sheet1!$A$1:$A$100,0))
(all one cell)

Drag down to A5 and drag A1:A5 to E1:E5

Each time the workbook recalculates, you'll get a new set of phrases.
(Hit F9 to force a new calc.)

=======
If you search google for "buzzword bingo", you may find a template that's
already been made.