Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scenario result display
I found my own answer. It is the Data Table
functionality. Thx anyway! -----Original Message----- Some one has sent me a spreadhseet in EXCEL 2002 with a matrix of values depending upon two vairables that can each take on multiple values. I want to create something similar. Let's assume one variable has 3 values and the other has 4. So we have a 3 by 4 matrix (not counting the potential vairable values that are shown at the top and down the side) of possible results from the combinations all shown together. I think I've figured out how to do sceanrio analysis in EXCEL but neither of the two choices (summary report or pivot table) seem to produce the simple exhibit that I see here. I notice that the eqaution shown in each cell of the 3 by 4 is identical and says {=TABLE (Q7,Q6)} and Q7 and Q6 are where the mid-range, base case, values of the two variables are. I assume that I must define some sort of group area to get mine to look this way. Can anyone tell me how this is done, please? Deana . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scenario result display
I don't know where you posted your question, but I don't think it was in
microsoft.public.excel.programming. We are all thrilled you found the answer, however. Regards, Tom Ogilvy Deana wrote in message ... I found my own answer. It is the Data Table functionality. Thx anyway! -----Original Message----- Some one has sent me a spreadhseet in EXCEL 2002 with a matrix of values depending upon two vairables that can each take on multiple values. I want to create something similar. Let's assume one variable has 3 values and the other has 4. So we have a 3 by 4 matrix (not counting the potential vairable values that are shown at the top and down the side) of possible results from the combinations all shown together. I think I've figured out how to do sceanrio analysis in EXCEL but neither of the two choices (summary report or pivot table) seem to produce the simple exhibit that I see here. I notice that the eqaution shown in each cell of the 3 by 4 is identical and says {=TABLE (Q7,Q6)} and Q7 and Q6 are where the mid-range, base case, values of the two variables are. I assume that I must define some sort of group area to get mine to look this way. Can anyone tell me how this is done, please? Deana . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming the Result Cells on a Scenario Summary | Excel Discussion (Misc queries) | |||
how to not display a certain result | Excel Discussion (Misc queries) | |||
Display scenario name | Excel Worksheet Functions | |||
How to display hidden rows maybe defined by scenario | Excel Worksheet Functions | |||
Display result as Yes or No | Excel Worksheet Functions |