排序 先考慮前面數字 (14505)

D2{=INDEX(B:B,RIGHT(SMALL(LEFT(SUBSTITUTE(B$2:B$16,"M",REPT(" ",9)),9)*10^8+RIGHT(SUBSTITUTE(B$2:B$16,"M",REPT(" ",9)),9)/1%+ROW($2:$16),ROW(A1)),2))



留言