Home > Software design >  Google Sheets - sequence function using array
Google Sheets - sequence function using array

Time:08-24

I have a table that contains a column with Initial Year and another with the number of amortisation years. I'm trying to generate a new table that duplicates the rows where amortisation years is >1 and recalcs the Year for each duplication.

I've drafted an example and the incomplete solution I got to so far:

example

enter image description here

  • Related