Hi,

I have used Solver to calculate an optimised solution for a particular set of data. I would like to get Solver to repeat the calculation but looking at data in different ranges. There are a few hundred ranges that I need Solver to consider so it's not feasible to run each scenario one-by-one and I lack the necessary skills to get VBA to do it for me.

Is it possible instead to replicate the Solver calculation using a formula in the spreadsheet?

Thanks