ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Data table around multiple scenarios (https://www.excelbanter.com/excel-worksheet-functions/140268-data-table-around-multiple-scenarios.html)

UNCCNU

Data table around 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 table that shows the results of all 3 options,
side-by-side, regardless of which scenario is selected. 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 06:29 AM.

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