Dec 29 2020 09:45 PM
HI,
I am working on one of the projects where I need to match the data manually genearted by Excel ->What If Analysis - Data Table.
I need the reference to how excel works in the back-end for the Data table function.
Dec 30 2020 03:26 AM
Excel simply substitutes the values in the row above the data table and/or the values in the column to the left of the data table into the formula in the upper left corner.
In the screenshot below, the formula is =A1+A2.
A1 is replaced with the values of B4, C4, ...
A2 is replaced with the values of A5, A6, ...
So for example B5 is calculated as =B4+A5, and H10 is calculated as =H4+A10