How to fill a matrix of 18 x 9 randomly

Msmits

New Member
Joined
Nov 6, 2015
Messages
2
Hi,

for a bingo game, I'm looking for a way to randomly fill a matrix of 18 rows by 9 columns with only 90 numbers (1 - 90). This means there are 72 open positions (or filled with zero's).

There are some rules to be applied to fill the matrix:

  • Each row can only have 5 numbers
  • The first column has 9 numbers
    • in the first column number 1 - 9 are used
  • 2nd till 8th column have 10 numbers
    • in the 2nd column number 10 - 19 are used
    • in the 3rd column number 20 - 29 are used
    • ...
  • Last column has 11 numbers (numbers 80-90)

Anyone some thoughts on how I can do this?
I can manage to get each row only using 5 number, the right set of number in every column but I cannot manage to get the total number by column correct....

Thanks for your input.
Maarten
 
I would agree with you Rick. After 3,500 loops last night, my random routine still did not produce 18 rows with 5 cells filled in each. The best I got was 10 of 18 rows with 5 cells filled in each.
 
Upvote 0

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Forum statistics

Threads
1,216,111
Messages
6,128,899
Members
449,477
Latest member
panjongshing

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top