Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Constrain Excel Solver solutions to a list?

I have a problem with 8 variables that I need to constrain to a list. I have
tried using validation, but it seems that solver disregards the validation
tool. is there a way to constrain to the list? There are about 55 different
values that the 8 variables could be equal to.
Reply
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
Solver giving solutions with decimals BRFx2 Excel Worksheet Functions 0 September 13th 07 06:12 PM
Writing a macro that updates solver solutions? tdogg241 Excel Worksheet Functions 2 May 31st 06 03:41 PM
how to constrain the sum of a range in solver a.raney Excel Discussion (Misc queries) 2 March 10th 06 11:44 AM
How to constrain input to previous entries SMUDGER New Users to Excel 1 January 20th 06 02:39 PM
Constrain to visible area? Ed[_9_] Excel Programming 7 August 6th 03 07:57 PM


All times are GMT +1. The time now is 07:23 AM.

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"