二欄數字排列組合 (13353)

F2 下拉=IF(ROW(A1)>SUM(B:B)*SUM(D:D),"",LOOKUP(ROW(A1)-1,SUM(D:D)*SUBTOTAL(9,OFFSET(B$1,,,ROW($1:$5))),A$2:A$6)&LOOKUP(MOD(ROW(A1)-1,SUM(D:D)),SUBTOTAL(9,OFFSET(D$1,,,ROW($1:$5))),C$2:C$6))