三項值的倍數 等於總和 取組合 (13909)

F2:H5{=IFERROR(T(OFFSET($A$1,COLUMN(A1),))&MID(SMALL(IF((MOD($D$2-ROW($1:$5)*$B$2-COLUMN($A:$E)*$B$3,$B$4)=0)*($D$2-ROW($1:$5)*$B$2-COLUMN($A:$E)*$B$3>0),ROW($1:$5)/1%+COLUMN($A:$E)*10+INT(($D$2-ROW($1:$5)*$B$2-COLUMN($A:$E)*$B$3)/$B$4)),ROW(A1)),COLUMN(A1),1),"")



留言