View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JC Home[_2_] JC Home[_2_] is offline
external usenet poster
 
Posts: 4
Default 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