Is it possible to create a single arrayformula that does the same thing as the following column of formula:
A1: =COUNTA(B1:B1)
A2: =COUNTA(B1:B2)
A3: =COUNTA(B1:B3)
...
A9: =COUNTA(B1:B9)
My best try was =ARRAYFORMULA(COUNTA(INDIRECT("B$1:"&B1:9))
but I get a circular dependency error - I presume because Arrayformula doesn't know which of the two possible ranges to expand over. I'd sort of need to tell it which array to expend and which not. Maybe there's a notation like "::" for that? Would be cool anyways.