Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Drop down list selections creating values in adjoining cell | Excel Worksheet Functions | |||
Creating a list of cell values | New Users to Excel | |||
Creating A Unique List of Values From A Table | Excel Worksheet Functions | |||
Creating a horizontal list of text values | Excel Discussion (Misc queries) | |||
Creating a Detailed List from a Summary List | Excel Worksheet Functions |