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.