Goal Seek With Multiple Input Cells

Originally Posted by Alf

After you have define the range of cells to change you add the constraints so you could selct the "dif" setting i.e. this ensures that ever cell in the range specified is different to each other.

How good this is? Don't know as I never have used it. Probably best not to specify to many cell as "dif"

Alf

I tried it, I still got duplicates. There must be additional constraints needed? I couldn't figure it out

I figured out the the Solver add-in was not giving duplicates. I did not select the Integer constraint, so I was getting fractional returns. Where I seen two 6's, I was actually getting 6.1 & 6.4, but my cells were formatted to show whole numbers only. The Solver works great, it can even do two separate ranges as input values. I'm glad I took a second look at this tool.