Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Scenario data
I know that Excel can store up to as many scenarios as you have memory
for - but is there a way to access the data across scenarios all at the same time? Trying to create a single file for forecasting - each scenario would represent the results from a specific time period, but it would be nice to make comparisons across scenarios easily. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Scenario data
In the Scenario manager dialog, there's a button for producing a Summary and
you can do a simple summary or a pivot table summary " wrote: I know that Excel can store up to as many scenarios as you have memory for - but is there a way to access the data across scenarios all at the same time? Trying to create a single file for forecasting - each scenario would represent the results from a specific time period, but it would be nice to make comparisons across scenarios easily. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What if scenario | Excel Discussion (Misc queries) | |||
scenario/what if ?? | New Users to Excel | |||
About Data Table & Scenario Manager. | Excel Worksheet Functions | |||
Scenario? | Excel Worksheet Functions | |||
IF Scenario | Excel Worksheet Functions |