Forum Discussion
automatically fill down the equation cells as the table growths
Hi, I have a table where I gather values from other spreadsheets. Is there a way to automatically fill down the equation cells as the table growths ? for example If I have cells A1:A10/B1:B10...
If the formula is not within the same Excel Table as the input data a dynamic array solution would size (spill) to match the data.
= Table1[Column1] + Table1[Column2]Using 365, the formula above references entire columns and returns an array of results containing the correct count of totals.