ROWNUMBERS returns an array of the row numbers of a 2D array (row of the array rather than of the worksheet)
Excel Formula:
=LAMBDA(array,SEQUENCE(ROWS(array))*SEQUENCE(,COLUMNS(array),1,0))| Lambda - Last Cell and Split.xlsx | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | |||
| 2 | this | is | my | 1 | 1 | 1 | |||
| 3 | array | of | words | 2 | 2 | 2 | |||
| 4 | or | numbers | like | 3 | 3 | 3 | |||
| 5 | 1 | 2 | 3 | 4 | 4 | 4 | |||
Sheet1 | |||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| F2:H5 | F2 | =ROWNUMBERS(B2:D5) |
| Dynamic array formulas. | ||
Last edited by a moderator:
Upvote
0
