B2{=INDIRECT(TEXT(MAX(IF((A2>=G$3:BA$15)*(G$3:BA$15>0)*MOD(COLUMN(G:BA),2),200+COLUMN(F:AZ))),"!R0C00"),)
C2{=INDIRECT(TEXT(RIGHT(MAX(IF((A2>=G$3:BA$15)*(G$3:BA$15>0)*MOD(COLUMN(G:BA),2),ROW($3:$15)/1%+COLUMN(F:AZ)*10001)),4),"!R0C00"),)
D2{=A2-MAX((A2>=G$3:BA$15)*G$3:BA$15)+1
留言
張貼留言