Forum Discussion
Solved
Deletion of previously generated data against the sequential column
Hello Team,
I am using a data to create number of rows based on user input number (for example the number choosen is 80), so the SEQUENCE command will generate 80 rows and using these row numbers other columns data is generated. However, when the number is changed to 60, the SEQUENCE command generates 60 rows as expected but the dependency columns data after 60th row is not deleted.
Kindly advice on how to proceed further
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.
