差異最小二數字 (9978)


 


D2{=OFFSET(B$1,MID(MIN(IF(ROW($1:$8)<>COLUMN(A:H),ABS(B$2:B$9-TRANSPOSE(B$2:B$9))/1%%+ROW($1:$8)/1%+COLUMN(A:H))),ROW(A1)*2,2),)


留言