Forum Discussion
Deletion of previously generated data against the sequential column
Do you have formulas that refer to the column with the result of the SEQUENCE formula? If so:
Let's say your =SEQUENCE(...) formula is in D2 (spilling down for ... rows).
Instead of referring to D2 in other columns and filling down, refer to D2# in a formula in row 2. The # will make that formula spill down the same number of rows as the SEQUENCE formula.
Otherwise, you could change =expression to =IF(D2="", "", expression) and fill down.
Do you have formulas that refer to the column with the result of the SEQUENCE formula? If so:
Let's say your =SEQUENCE(...) formula is in D2 (spilling down for ... rows).
Instead of referring to D2 in other columns and filling down, refer to D2# in a formula in row 2. The # will make that formula spill down the same number of rows as the SEQUENCE formula.
Otherwise, you could change =expression to =IF(D2="", "", expression) and fill down.