GeertD
Board Regular
- Joined
- Dec 22, 2020
- Messages
- 60
- Office Version
- 365
- Platform
- Windows
PUTCOLUMN: In an Array put a ColumnVector on a specific ColumnNumber.
Excel Formula:
=LAMBDA(Array,ColVector,ColNr,
IF(ROWS(Array)=ROWS(ColVector),IF(SEQUENCE(,COLUMNS(Array))=ColNr,ColVector,Array),"#DimError!")
)| DXLR's LAMBDA.LET Library_v00.07.xlsb | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | -1 | -2 | -3 | Keyon | ||||
| 2 | 1 | 4 | 6 | Talon | ||||
| 3 | 1 | 6 | 9 | Carina | ||||
| 4 | ||||||||
| 5 | -1 | Keyon | -3 | |||||
| 6 | 1 | Talon | 6 | |||||
| 7 | 1 | Carina | 9 | |||||
| 8 | ||||||||
Sandbox_Mr.Excel | ||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| A5:C7 | A5 | =PutColumn(A1:C3,E1:E3,2) |
| Dynamic array formulas. | ||
Upvote
0
