ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Scenario data (https://www.excelbanter.com/excel-worksheet-functions/214467-scenario-data.html)

[email protected]

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.


Bob Umlas, Excel MVP

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.




All times are GMT +1. The time now is 01:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com