排列組合 (10926)

F1:H1下拉=IF(ROW(A1)>PRODUCT(MMULT(COLUMN(A:I)^0,N($A$1:$D$9<>""))),"",OFFSET(A$1,MOD(INT((ROW(A1)-1)/PRODUCT(MMULT(COLUMN(A:I)^0,N(B$1:$D$9<>"")))),COUNTA(A:A)),))

I1下拉=IF(F1="","",OFFSET(D$1,MOD(ROW(A1)-1,COUNTA(D:D)),))