Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts

[ThinhDinh]

This post was inspired by:

• A discussion with @nathanaelb when he solved a problem by the sequence function.

Group by to filter data

You can wrap arrayformula() around sequence() to create decimal numbers within the sequence, since the sequence() function does not allow decimal counts: [image] What I don’t know how to do is pull sequence() down the column.

• A time when I helped @Robert_Petitto when his arrayformula just works with the first row and it populates the other rows with the same information.