GeertD
Board Regular
- Joined
- Dec 22, 2020
- Messages
- 60
- Office Version
- 365
- Platform
- Windows
FLIPARRAYH: Flip array horizontally, left to right.
Excel Formula:
=LAMBDA(A,LET(
RowsA,ROWS(A),ColsA,COLUMNS(A),
INDEX(A,SEQUENCE(RowsA),SEQUENCE(,ColsA,ColsA,-1))
))| 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 | 3 | 2 | 1 | |||
| 6 | 3 | 2 | 1 | |||
| 7 | 3 | 2 | 1 | |||
| 8 | ||||||
Sandbox_Mr.Excel | ||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| A5:C7 | A5 | =FlipArrayH(A1:C3) |
| Dynamic array formulas. | ||
Upvote
0
