排列組合 三資料跳欄 (13169)

H2=OFFSET(B$1,INT((ROW(A1)-1)/COUNTA(D$2:D$8)/COUNTA(F$2:F$8))+1,)&""

I2=IF(H2="","",OFFSET(D$1,MOD(INT((ROW(B1)-1)/COUNTA(F$2:F$8)),COUNTA(D$2:D$8))+1,))

J2=IF(H2="","",OFFSET(F$1,MOD(ROW(A1)-1,COUNTA(F$2:F$8))+1,))



留言