排序 分前 後數字 (14777)

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

E2{=INDEX(B:B,RIGHT(SMALL(LEFT(B$2:B$16,FIND("-",B$2:B$16)-1)/1%+ROW($2:$16),ROW(A1)),2))

F2{=INDEX(B:B,RIGHT(SMALL(MMULT(MID(SUBSTITUTE(B$2:B$16,"-",REPT(" ",9)),{1,9},9)*1,{1;1})/1%+ROW($2:$16),ROW(A1)),2))



留言