H2:I3{=MID(RIGHT(MAX(($A$1:$E$10/1%%+ROW($1:$10)/1%+COLUMN($A:$E))*-1^($G2=$G$3)),4),COLUMN(A1)*2-1,2)*1
J2:J3=ADDRESS(H2,I2,4)
J2:J3 無用 H:I{=ADDRESS(RIGHT(MAX((A$1:E$10/1%+ROW($1:$10))*-1^(G2=G$3)),2),RIGHT(MAX((A$1:E$10/1%+COLUMN(A:E))*-1^(G2=G$3)),2),4)
留言
張貼留言