UPPERARRAY

[GeertD]

UPPERARRAY: Extract the upper 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	2	3
6	0	0	3
7	0	0	0
8
Sandbox_Mr.Excel

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