Solver Question

[chisox721]

I've recently been using Solver to pick out optimal baseball lineups provided their cost and how much I think they're worth. Solver runs fine, but my issue is when I attempt to run it the next day with a different number of players for each position I have to go into the Solver parameters box and reenter the named ranges for the changing cells. Is there any way to make Solver automatically notice the named ranges change in size?

Hopefully my question makes sense and thanks in advance for any help.

[ajryan88]

Hi,

You can set up dynamic named ranges using the OFFSET function, like the following example:

Please Login or Register  to view this content.

This will return a range that is 1 column wide and the height of the range will depend on how many numeric values are in the range A1:A100. These specifics can obviously be changed to suit your needs.

If you need/want some help to try this, please upload your workbook (Reply --> Go Advanced --> Manage Attachments).

I hope this helps

[chisox721]

Well I tried it, but unfortunately when I run Solver it doesn't want to recognize that I've added changing cells, so I still have to go in and reenter each individual named range. I'm thinking I may have to use code to solve this issue but not sure I'm ready for that.

[Saarang84]

Hi,

Kindly post a copy of your solver workbook (without sensitive information, mock up info probably) for us to get to understand your problem and code a solution for it.