solver

N

Need Help Fast!

I have a macro that runs and pulls a bunch of data out of access based on
certain criteria. It works fine. Then I go into manually run the solver. I am
maximizing a value and wanting to keep a set of 24 weights, when summed up,
equal to one. Also, the maximum of any of these weights cannot be 2. The
problem is solver just sets all of my weights to the same number. Is there a
way around this? Thanks
 
T

Tom Ogilvy

Put in a two formulas
=Sum(A1:A24)
=Max(A1:A24)

(as examples)

then put in constraints to limit the values for those formulas (cells that
contain the formulas).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"DoEvents"-type behavior in Solver? 1
Connection between Solver add-in and file path code 0
Using solver in vba to max value by changing weights? Help??? 2
Excel 2007: Creating a macro that will run Solver. 0
Excel 2007: Help creating a macro that will run Solver? 3
Excel 2007: Help creating a macro that will run Solver? 0
Problem with Solver add-in. Changing values 1
Solver slow 0

Top