Multi-Cell Goal Seeker

[max4asd]

Hi,


its a great forum and i thanks everybody who shares and provide solutions for the people in excel.


The goal seeking feature of Excel is great - if you just do a few cells. But if you have to do goal seeking on many cells, the work gets painful fast. Can we do Multi-Cell Goal Seeker for Excel which can do goal seeking for many cells, one after another at same time.


Do anybody have any idea about it please share with me.


Thanks

 

[Faseeh]

Hi max4asd,


I think 'Solver Add-in' could do the trick for you, try that.


Regards,

Faseeh

 

[max4asd]

Thansk Mr. Faseeh,


How to add this add in excel could you please eloborate.


How to use it once the addon is available.


Thanks

 

[Luke M]

Hui's article might help you get started:

http://chandoo.org/wp/2011/05/11/using-solver-to-assign-item/

 

[dan_l]

also high awesome factor:


http://opensolver.org/