Hi! I have two types of variables (type A1, A2, A3…) and (type B1,B2,B3…). Each variable of both types has multiple values that are retrieved through a V-lookup table.
The combination of these two variables is a Scenario (ex. ‘typeA1-typeB1’ is one Scenario, ‘typeA2-typeB3’ is another…etc. There is always a typeA, and always a typeB. ). The values of each variable are used in several calculations for each Scenario. The results of these calculations are set in a column. Most important to me is the Max of this column. That Max falls in Cel Z10. Currently, I can only get the Max for one Scenario at a time. To do another, I need re-plug in the new two-variable Scenario that I want to look at. I’m looking to get the Max for several Scenarios at once. I am envisioning this happening by listing the two variables (typeA and typeB) side by side (which would denote the Scenario) and then having a third column (in that same line) that procures the Max of that particular Scenario.
You can assume the typeA and typeB variables are in columns A (A1-A20) and B (B1-B20) respectively, and each line (of those two values) is a Scenario. We’ll say for 20 lines for 20 Scenarios. I’m looking for the syntax that would be in column C and I am hoping for Max values (for each of the respective scenarios) to be displayed in Cels c1-c20. I’m pretty sure I will also have to change the syntax in Cel Z10, which is currently just the Max function – and that would be a help, too!
I’ve tried to lay this out as clearly as I could, but I could have missed something – I’d be happy to clarify if I can – just let me know.
Thanks for all your efforts!
Pete
The combination of these two variables is a Scenario (ex. ‘typeA1-typeB1’ is one Scenario, ‘typeA2-typeB3’ is another…etc. There is always a typeA, and always a typeB. ). The values of each variable are used in several calculations for each Scenario. The results of these calculations are set in a column. Most important to me is the Max of this column. That Max falls in Cel Z10. Currently, I can only get the Max for one Scenario at a time. To do another, I need re-plug in the new two-variable Scenario that I want to look at. I’m looking to get the Max for several Scenarios at once. I am envisioning this happening by listing the two variables (typeA and typeB) side by side (which would denote the Scenario) and then having a third column (in that same line) that procures the Max of that particular Scenario.
You can assume the typeA and typeB variables are in columns A (A1-A20) and B (B1-B20) respectively, and each line (of those two values) is a Scenario. We’ll say for 20 lines for 20 Scenarios. I’m looking for the syntax that would be in column C and I am hoping for Max values (for each of the respective scenarios) to be displayed in Cels c1-c20. I’m pretty sure I will also have to change the syntax in Cel Z10, which is currently just the Max function – and that would be a help, too!
I’ve tried to lay this out as clearly as I could, but I could have missed something – I’d be happy to clarify if I can – just let me know.
Thanks for all your efforts!
Pete