非空取排列起止數據 (13585)

N2{=IF(ROW(A1)>L$6-L$2+1,"",INDIRECT(TEXT(SMALL(IF(A$2:J$16<>"",ROW($2:$16)/1%+COLUMN(A:J)),ROW(A1)+L$2-1),"!R0C00"),))

A2:J16格式化=(SUMPRODUCT(N($A2:A2<>""))+SUMPRODUCT(N($A$1:$J1<>""))>$L$2)*(SUMPRODUCT(N($A2:A2<>""))+SUMPRODUCT(N($A$1:$J1<>""))-2<$L$6)*(A2<>"")