ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Summary table for multiple scenarios (https://www.excelbanter.com/excel-discussion-misc-queries/140237-summary-table-multiple-scenarios.html)

UNCCNU

Summary table for multiple scenarios
 
I have a file with numerous tabs of calculations, etc. that results in a nice
summary tab already created. I also have 3 "scenarios" whereby if I select
Low, Medium, or High, it filters through my calculations to show 3 different
results, depending on what is selected. What I am trying to do is create a
new tab with a basic output that shows the results of all 3 options,
side-by-side, regardless of which scenario is selected.
As an aside, does that table have a specific "name" - which I can then also
look up in Excel Help?



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

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