I would like to get from different scenarios the combinations of scenarios which generates the highest revenue given a certain costsbudget.
I think I will need a Macro that will go through all combinations of scenarios within the budget and than show me the one with the highest revenu. I have tried with formulas but that is not working at all. The number of chosen scenarios in the output is irrelevant. It can be one or it can be all.
In the attachment I give an example how it should work. I work with up to a thousands scenarios. The scenarios or budget are not fixed. I am completely stuck on this, maybe anyone can help? thanks in advance!!!
Bookmarks