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