Forum Discussion
Adding a formula to a column and make it auto-repetitive and deactivate the column
Hi Guys, I want to add a formula to the column to the first cell, and then to be repeated for each new row, knowing that I want to disable this column because it is calculated and I do not want the ...
This formula will multiply column B with Column C for each row. Calculated with ROWS:
=INDEX(B2:C11;SEQUENCE(ROWS(B2:B11)),1)*INDEX(B2:C11;SEQUENCE(ROWS(B2:B11)),2)
Lock and password protect column A