排列組合 (9967)

F2:H2 下拉 {=IF(ROW(A1)>PRODUCT(MMULT(COLUMN(A:O)^0,N($B$2:$D$16<>""))),"",OFFSET(B$2,MOD(INT((ROW(A1)-1)/PRODUCT(TEXT(MMULT(COLUMN(A:O)^0,N(C$2:$E$16<>"")),"0;;1")*1)),COUNTA(B:B)-1),))