solver

[Guest]

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

 

[Guest]

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).

 

[Guest]

Sorry, that's what I did, and it doesn't work. Thanks