Is there a way to create a Dynamic what If analysis instead of the static table/new sheet output?
Thanks
Is there a way to create a Dynamic what If analysis instead of the static table/new sheet output?
Thanks
Dynamic in what way? Are we talking about What if data table?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I don't think I am looking for a data table, I have two columns that are independent with multiple (14) variables that will change a standard deviation value. I can do it using what if and it will give me the static output page, I am wondering if I can have a similar outcome but have the "What if Scenarios" in columns adjacent to to the master one. Hope that explains what I am looking to accomplish.
Thanks
Nope, can you upload an example? (Go Advanced>Manage Attachment)
Unless we're talking about an optimization scenario, Excel should be able to do this but I need to see it to understand exactly what you are looking for.
Sorry for the delay, I created a new work book to upload. It's a bit messy but I think it will achieve the goal. You will see orange highlighted cells, what I am trying to do is a sort of what if analysis on cells U37 & U38 if the cells in U29:U31 equal the value in V29:V31, W29:W31, and so on. I can do this as what if analysis but if I change any of the variable values U29:U31 and S29:S31 I would need to redo the what if each time. Looking for a way to make it display in the orange area. I can do it one at a time but I would like to have a side by side comparison to analyse the impact of changes.
Thanks
Book2.xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks