二數相加 等於指定數 (13108)

G2:H9{=IFERROR(RIGHT(INT(SMALL(IF($B$2:$B$9+TRANSPOSE($C$2:$C$9)=$E$2,$B$2:$B$9*10^9+TRANSPOSE($C$2:$C$9)),ROW(A1))/10^9^(B$1=$B$1)),9)*1,"")



留言