Forum Discussion
Add row and copy formula
Hello, I wonder how I add an entire row and take the formulas from below. And also, I'm adding a row at the top side, and I have 1 parameter that calculates the las 13 data. By that I need the oldest...
If you are inputting basic data, this is best done using an Excel table. To insert values at the top requires you to insert a row to the sheet, but any formulas should extend to include the new row. Using 365 a formula to return the sum of the top 13 items of a value field would be
= SUM(
TAKE(Table1[value],13)
)Similar things can be done using INDEX:INDEX