Create Bingo Cards from Word List

Attach the workbook here.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Hello pfdizzy and Welcome to Excel Forum.
I hope that this may help and also that it will provide a spark that will inspire someone else to make improvement.
1) Columns B:G are populated using the Rand() function,
2) M1 is 66 and M2 and down is populated using: =IF(MOD(ROW(),5)=1,M1+1,M1)
3) The first Bingo Card is populated using:

Formula:

Please Login or Register  to view this content.

After the formula has been copied over and down to cell L5 and while the range I2:L5 is selected
1) Copy the range (Ctrl + c)
2) Select cell I7 and paste (Ctrl + v)
3) While the range I7:L10 is still selected edit the part of the formula that will now read ROW(6:6) so that it reads ROW(1:1)
4) Press Ctrl + Enter to confirm the change leaving the range selected.
Repeat the 4 steps above for each Bingo Card.
Let us know if you have any questions.

This sample may help. Its an alternate way of doing random excludes. The sample does numeric's, but you should be able to setup a key of text in a column someplace and pull from it.

See the bingo sheet. As is, you just copy a "card" on that sheet to another area to create additional cards. So you should be able to create as many as you like. Ill see if I can add the text key to it later.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

Administrative Note:

Hello shihfa and Welcome to Excel Forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Let us know if you have any questions.