16. Sequence by rows


=2.SEQUENCE(1.(ROWS(B4#));

This formula is a SEQUENCE function that returns an array of sequential numbers from 1 to the number of rows in the range B4#. For example, if the range B4# contains 5 rows, the formula will return the following array: 1 2 3 4 5


  1.  It determines the number of rows. If you apply "#" it will determine the number of rows in that column;

  2.  When you apply "Sequence" to the previous function, since we have an array, it counts as a sequence.
ROWS

Rows - Syntax

ROWS(array)

It determines the number of rows. In this case: 1.

At our table:

Destiny 1 Rows
21
61
SEQUENCE

Sequence - Syntax

SEQUENCE(rows, [columns], [start], [step])

When the number of rows are determined we can have a sequence.

At our table:

Batch number
1
2