Bingo Card

[sinspawn56]

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.

[shg]

If you can use VBA ...

Add this UDF to your workbook:

Please Login or Register  to view this content.

The select A1:E5 and paste this formula into the formula bar:

=INDEX(A6:A52, RandLong1())

Don't press Enter; instead, press and hold the Cntl and Shift keys, then press Enter.

[sinspawn56]

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.

[shg]

Format that cell as ;;;"Free". Or put a picture over it.

[sinspawn56]

Most Excellent. Works perfectly. Thank you.

[mimiluni]

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!

[Jakobshavn]

Here is a version without VBA.