I am currently trying to make number increment based on a cell value For example, if the cell value is 5, then a number increment should appear shows in row by row as

1
2
3
4
5

Anyone has ideas on how to do this?

CodePudding user response：

You need SEQUENCE() function. Try-

=SEQUENCE(B1)

Reference:

• SEQUENCE