二個三位數和 求二數字 (13285)

E2:E3{=MID(MIN(IF((COLUMN(A:J)-1)*10+LEFT(C$2)/1%+RIGHT(C$2)+(MID(TEXT(ROW($1:$999),"000"),2,1)-MID(C$3,2,1)=0)*ROW($1:$999)=C$4,(((COLUMN(A:J)-1)*10+LEFT(C$2)/1%+RIGHT(C$2)))*1000+ROW($1:$999))),ROW(A1)*3-2,3)*1

E4=SUM(E2:E3)

另解 E2:E3=ABS(C$4*(C3=C$3)-LOOKUP(1,0/(MID(TEXT(C$4-(LEFT(C$2)&(ROW($1:$10)-1)&RIGHT($C$2)),"000"),2,1)-MID(C$3,2,1)=0),C$4-(LEFT(C$2)&(ROW($1:$10)-1)&RIGHT($C$2))))