對應數字 相減 (12384)

K3:N5{=IFERROR(G3-INDIRECT(TEXT(MAX(IF(C3=$C$2:$F2,ROW($2:2)/1%+{7,8,9,10})),"!R0C00"),),"")

另解{=IFERROR(G3-RIGHT(LARGE(IF($C$2:$F2=C3,$G$2:$J2+ROW($1:1)/1%),1),2),"")



留言