✔ 最佳答案
=INDEX(A$1:A$3,MOD(INT((ROW(A1)-1)/3^4),3)+1)*INDEX(B$1:B$3,MOD(INT((ROW(A1)-1)/3^3),3)+1)*INDEX(C$1:C$3,MOD(INT((ROW(A1)-1)/3^2),3)+1)*INDEX(D$1:D$3,MOD(INT((ROW(A1)-1)/3^1),3)+1)*INDEX(E$1:E$3,MOD(INT((ROW(A1)-1)/3^0),3)+1)
下拉複製
2015-06-26 20:55:43 補充:
=INDEX(A$1:A$3,MOD(INT((ROW(A1)-1)/3^4),3)+1)&"*"&INDEX(B$1:B$3,MOD(INT((ROW(A1)-1)/3^3),3)+1)&"*"&INDEX(C$1:C$3,MOD(INT((ROW(A1)-1)/3^2),3)+1)&"*"&INDEX(D$1:D$3,MOD(INT((ROW(A1)-1)/3^1),3)+1)
2015-06-26 20:56:08 補充:
續上
&"*"&INDEX(E$1:E$3,MOD(INT((ROW(A1)-1)/3^0),3)+1)
下拉複製
2015-06-28 22:01:16 補充:
因為不曉得版大要哪一種
意見 004 是結果
005 & 006 是算式
2015-06-28 22:01:45 補充:
請試 004
....
2015-06-28 22:03:00 補充:
=INDEX(A$1:A$3,MOD(INT((ROW(A1)-1)/3^4),3)+1)*INDEX(B$1:B$3,MOD(INT((ROW(A1)-1)/3^3),3)+1)*INDEX(C$1:C$3,MOD(INT((ROW(A1)-1)/3^2),3)+1)*INDEX(D$1:D$3,MOD(INT((ROW(A1)-1)/3^1),3)+1)*INDEX(E$1:E$3,MOD(INT((ROW(A1)-1)/3^0),3)+1)
下拉複製