Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Varying list of input variables and cell references in Solver

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 3 posts



I got another question.


I'm trying to use the Solver in Excel.  But I have a list of input variables in which the number of cells is dependent on the number in another cell.


For example, if Cell A1 is 4, the number input variables will be 4, and could be from A2:D2.


Also, for the constraints, I would like to have the cell references to be A2:D2 to be <20.


I have tried to named reference, but once I enter the reference, it shows the absolute cell reference (eg. A2:D2) rather than the name.


As a result of this, whenever I want to run, I need to refresh the input variables and the constraints, which could be quite troublesome.


Is it possible to overcome this without resorting to programming macros?


Thanks very much.


  • 0


Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP