C2=LOOKUP(1,-RIGHT(A3,ROW($1:$9)),LEFT(RIGHT(A3,ROW($1:$9)),2))
另解{=MID(A2,LEN(A2)-COUNT(-RIGHT(A2,ROW($1:$9)))+1,2)
另解{=LEFT(RIGHT(A2,COUNT(-RIGHT(A2,ROW($1:$9)))),2)
另解=LOOKUP("a",MID(A2,99-ROW($1:$98),2))
另解{=MID(A9,MATCH(1,N(INDIRECT(MID(A9,ROW($1:$19),1)&1)))+1,2)
留言
張貼留言