B2{=INDEX(A:A,RIGHT(SMALL(SUBSTITUTE(A$2:A$9,"-",".")*10^8+ROW($2:$9),ROW(A1)),2))
C2{=INDEX(A:A,RIGHT(SMALL(LEFT(A$2:A$9,FIND("-",A$2:A$9)-1)*10^8+MID(A$2:A$9,FIND("-",A$2:A$9)+1,9)/1%+ROW($2:$9),ROW(A1)),2))
另解 C2=INDEX(A:A,RIGHT(SMALL(IMREAL(A$2:A$9&"j")*10^8+-IMAGINARY(A$2:A$9&"j")/1%+ROW($2:$9),ROW(A1)),2))
留言
張貼留言