I know, I know. How the tables have turned. Literally!
I havent used Excel for years and in that time it appears MS have joined the 21st century and put excel online. Bravo.
I want to do some analysis which I used to do all the time in Excel, but not for many years and so have never done it in Google Sheets and not sure I can even do it without writing scripts.
In Excel:
Assume a simple function:
Variable X = x
Variable Y = y
Z = X*Y
I used to be able to “Insert Data Table” where I’d enter in the tops of each column an array of x values and the left of each row an array of y values. At the “1,1” of the table in the gap between these two arrays would be a reference to a formula that used those variables (=X*Y) in this instance.
Excel would then ask which set of variables to substitute for “X” and which for “Y” (you then select the correct arrays. The undo and select the other set of arrays because I always got that wrong first time) and it would populate the grid with all the values based on those variables and the formula, and it would maintain that calculation.
How do I do this in Excel online as everything has moved or disappeared?