Get current Row number inside ArrayFormula

The following may be a little simpler:

=arrayformula(ROW(INDIRECT("A"&ROW()&":A")))

=index(ROW(INDIRECT("A"&ROW()&":A")))

You need to specify a cell-range argument for ROW() in order to have more than one value.

Try it this way:

=ARRAYFORMULA(ROW(A1:A10))

This will fill a column with row numbers from 1 to 10.

Related