排列組合 (9879)

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