Forum Discussion
Using arrays calculations in Excel.
vifacc44 Thank you for providing a complete sample file. The header cell for the "Safety Factor" column of the output table needs to be linked to the final result that is dependent on the "Shape" selection in cell B8 (the final result appears to be in cell D28, "Factor of Safety"). Then, select the entire 2-column output range, go to Data > What-If Analysis > Data Table... on the ribbon and set the Column input cell to $B$8.
I've outlined the setup process in the attached file for your convenience...
This is the link to my public OneDrive which contains the excel sheet explaining the problem.
https://1drv.ms/f/s!ArE7UagGehaigotFtl-2MQy2mA-xVA?e=ua5wPX
Vittorio
- Hello!...is there anyone out there?
And yet this line of code {=TABLE(;$B$10)} works, but I can't find any references to it
Vittoriovifacc44 The array formula you are referring to was created by going to Data > What-If Analysis > Data Table... on the Ribbon. As mentioned by mathetes, it's difficult to provide any further explanation because all of the data on which it was built has been removed from your sample file. For more information, please see Calculate multiple results by using a data table or Google search "data tables excel" and see what comes up. Cheers!
- Thanks Mathetes and Djclements for your kind reply.
I apologize for my superficiality, I thought that the outline was not important because it seemed to me that the only cells involved were those indicated by me.
I thank Djclements in particular for the references that he kindly wanted to indicate to me and that I am about to study.
When I have sufficiently mastered the problem, I will also be able to develop a more precise worksheet.
Vittorio
For what it's worth, opening your spreadsheet reveals almost nothing. Here's an image of what one sees. I think you need to do a better job of "explaining the problem" -- or at the very least, making it visible. It looks like a big blank sheet except for the cryptic presence that you see below.
