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