LOWERARRAY

[GeertD]

LOWERARRAY: Extract the lower part of an array.

=LAMBDA(A,LET(
   RowsA,ROWS(A),Rowdex,SEQUENCE(RowsA),
   ColsA,COLUMNS(A),Coldex,SEQUENCE(,ColsA),
   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	0	0	0
6	1	0	0
7	1	2	0
8
Sandbox_Mr.Excel

Cell Formulas
Range	Formula
A5:C7	A5	=LowerArray(A1:C3)
Dynamic array formulas.