後面有數字 放後面 (13757)

D2{=INDEX(B:B,RIGHT(SMALL(ISNUMBER(-RIGHT(B$2:B$16))/1%+ROW($2:$16),ROW(A1)),2))



留言