Forum Discussion
How to Compare Multiple Scenarios Dynamically in Excel Without Displaying All Scenarios in One Table
Hello everyone, I’ve created a dynamic cash flow model in Excel that is based on four different scenarios. Each scenario is selected using a formula (CHOOSE) that pulls the scenario from a specifi...
There can certainly be a solution for that purpose.
However, it is quite difficult to provide an exact reply to solve that problem without knowing how your data and/or sheet looks like. I would recommend sharing a sample workbook without sensitive data in order to offer a suitable solution. If that is not possible, a couple of screenshots and further explanation of your current formulation/situation would be helpful.