Help needed to make game with bingo random qualities

**frednufc** · 11-05-2013, 01:00 PM

Hi all,

I am looking for help to a problem I have given myself and I just can't solve.
I am trying to make and excel sheet with a 5x3 grid and I want to put the names of various countries flags (easy) BUT, I want them to randomly put different names in to different boxes (like bingo Nos) is this possible??

any help would be great
Thanks
Frednufc

**arlu1201** · 11-05-2013, 01:09 PM

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**frednufc** · 11-06-2013, 12:23 PM

have changed but don't really know what to put
Sorry

**ben_hensel** · 11-06-2013, 12:36 PM

Generally speaking you can leave "Help needed" implicit in thread titles; "Randomly Filled Table" means pretty much the same thing as "Help with Randomly Filled Table", for example.

Anyway I used a 5x3 table filled with RAND and a list of NAMES as inputs, and then filled an output table with:
=INDEX(name_list, rank(random_number, table_of_random_numbers))

**frednufc** · 11-07-2013, 07:01 PM

thanks for the reply, I have attached an old file I had with an old game, but this is the way I want to do it and I just can't remember how, when and why I did it... can you help with this... Think I have attached it correctly

Thanks