Creating a list of values
I am just getting back into programming and would like to create a program
to solve Su Doku puzzles as a refresher. I have created a table on top for
the user to input the values and another below that for the solution. In
the solution table, I will have it check to see if there is a value in the
corresponding cell in the input table via an IF THEN ELSE formula.
If there is a value, it will simply be copied down. If there isn't, I would
like to check to see which numbers (1-9) are in that row, in that column,
and within the 3x3 block (1-3, 1-3) and eliminate those as possible values
for that cel, but can I create a LIST of values? For example, lets say that
1, 4, 5, 7, and 9 are already present in the row, column, or block. That
means that cell 1,1 cannot be those values, but it could be 2, 3, 6, or 8.
I would then continue populating each cel with possible choices until I got
to cel 9,9.
Any suggestions would be greatly appreciated! Thanks in advance.
--
Jeff C
|