任二數加總 = 指定值 提任一組合 (14526)

 F2:G11{=INDEX($B:$B,MID(TEXT(MAX(($C$2:$C$16+TRANSPOSE($C$2:$C$16)=$E2)*(ROW($1:$15)>COLUMN($A:$O))*(ROW($2:$16)/1%+COLUMN($B:$P))),"0000"),COLUMN(A1)*2-1,2))



留言