Dynamic scenarios - more than 2 variable using data tables in Exc

V

Varghese

Is it possible to create a 'dynamic' scenario analyser in Excel using/linking
one/multi variable data table (Data --> Tables)? The problem with Tools -->
Scenarios is that it is not dynamic and flexible as 'data tables', even
though we could feed in more variables. The Tools --> Solver gives us only
one scenario at a time. Please help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables. 0
What Multiple functions do I need? 2
Data Validation List with blanks 1
Importing / Linking Dynamic Data or ASP Tables into Excel ? 0
ListObjects - VBA code that worked in previous versions of Excel doesnot work in Excel 2013 0
How I can set dynamic pivot table ONLY when I have enough data point 1
Multiple Tables and Multiple Pivot Tables Help 0
Scenario/Pivot Tables 2

Top