GeertD
Board Regular
- Joined
- Dec 22, 2020
- Messages
- 60
- Office Version
- 365
- Platform
- Windows
DIAGARRAY: Extract the diagonal part of an array.
Excel Formula:
=LAMBDA(A,LET(
RowsA,ROWS(A),Coldex,SEQUENCE(,ColsA),
ColsA,COLUMNS(A),Rowdex,SEQUENCE(RowsA),
IF(Rowdex=Coldex,A,0)
))| DXLR's LAMBDA.LET Library_v00.07.xlsb | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | 1 | 2 | 3 | |||
| 2 | 1 | 2 | 3 | |||
| 3 | 1 | 2 | 3 | |||
| 4 | ||||||
| 5 | 1 | 0 | 0 | |||
| 6 | 0 | 2 | 0 | |||
| 7 | 0 | 0 | 3 | |||
| 8 | ||||||
Sandbox_Mr.Excel | ||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| A5:C7 | A5 | =DiagArray(A1:C3) |
| Dynamic array formulas. | ||
Upvote
0
