I am trying to make a bingo sheet using US States instead of numbers.
I have the basic 5x5 grid with the center cell being a free cell.
I need to populate the grid with random yet unique states (so that the states don't appear on the card more than once)
Any ideas?
I have attached my bingo template.
Last edited by sinspawn56; 03-09-2011 at 09:37 PM.
If you can use VBA ...
Add this UDF to your workbook:
The select A1:E5 and paste this formula into the formula bar:
Please Login or Register to view this content.
=INDEX(A6:A52, RandLong1())
Don't press Enter; instead, press and hold the Cntl and Shift keys, then press Enter.
Entia non sunt multiplicanda sine necessitate
The only issue I have with that is that it overwrites the Free cell which is C3. I do not want a state to appear here.
Format that cell as ;;;"Free". Or put a picture over it.
Most Excellent. Works perfectly. Thank you.
Re: Bingo Card
this was perfect! the VBA works like magic! thanks for this post!!
i simply placed an image for the FREE SPACE and the VBA works like a charm. i'm totally geeking out over this!
Here is a version without VBA.
Gary's Student
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks