二儲存格名稱 移動格數 左右移動格數+上下移動格數 (13088)

D2=ABS(SUMPRODUCT((ADDRESS(ROW($1:$99),COLUMN(A:CU),4)=B2)*COLUMN(A:CU))-SUMPRODUCT((ADDRESS(ROW($1:$99),COLUMN(A:CU),4)=C2)*COLUMN(A:CU)))+ABS(SUMPRODUCT((ADDRESS(ROW($1:$99),COLUMN(A:CU),4)=B2)*ROW($1:$99))-SUMPRODUCT((ADDRESS(ROW($1:$99),COLUMN(A:CU),4)=C2)*ROW($1:$99)))

另解{=SUM(LARGE(COUNTIF(B2:C2,ADDRESS(ROW($1:$99),COLUMN(A:CU),4))*ROW($1:$99),{1,2})*{1,-1})+SUM(LARGE(COUNTIF(B2:C2,ADDRESS(ROW($1:$99),COLUMN(A:CU),4))*COLUMN(A:CU),{1,2})*{1,-1})