LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop down list selections creating values in adjoining cell WoodyAccess Excel Worksheet Functions 1 November 18th 08 07:03 PM
Creating a list of cell values Link New Users to Excel 3 February 14th 08 09:32 AM
Creating A Unique List of Values From A Table carl Excel Worksheet Functions 8 May 17th 07 11:39 AM
Creating a horizontal list of text values Kelly Excel Discussion (Misc queries) 1 January 9th 07 05:00 PM
Creating a Detailed List from a Summary List [email protected] Excel Worksheet Functions 0 September 7th 06 12:36 AM


All times are GMT +1. The time now is 07:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"