Fitting characters to a grid

M

Marcus Fox

In Excel I will have a grid sized 36 x 36, and this grid is subdivided into
36 6 x 6 boxes. What I would like to do is auto fill the grid randomly with
the characters A-Z and 0-9. However, in each row and in each column, each
character will appear only once. In addition, each character will appear
only once in each 6 x 6 box. Sort of like a giant Sudoku puzzle.

Any idea how I could formulate this?

Marcus
 
B

bgeier

WOW!!!:eek:
You do not want much do you???:rolleyes:

Just to be sure I understand.
In row 1 (for example) you would have a-z then 0-9 (randomly
distributed) in columns "A" to "AJ"
Then in row 2 you would have b-z,a then 0-9 (again randomly
distributed) in columns "A" to "AJ"
Continue down to row 36
(I used the pattern above to demonstrate no two cells in a row or
column would be the same value)

Each cell must be a random value between "a" and "z" and/or "0" and "9"
not repeated on the same row or same column.

Off of the top of my head you would have to use some type of array of
arrays, then compare each internal array to each other.
 
P

Pete_UK

You could fill the first row randomly, but thereafter the rows will
have to comply with the rules of the grid, so you will not have a truly
random distibution on the second row - rather a constrained
distribution. As you add more rows, the degree of constraint will
increase.

Pete
 
Top