Change formula
As the attachments show, the formula of column ROW(3) is effective but just for one row. The formula of column "Used For loop " as below color shows, I know that formulas can't contain For loops, so remove the For loop parts and change ":Scan input[i]" to other expressions or other functions to Implement from ": Scan input[1]" to": Scan input[end row number]", then automatically updated base...