排序 右邊數字優先 同數考慮左數 (14897)

D2:E9{=OFFSET(A$1,RIGHT(SMALL(MMULT(TEXT({1,-1}%,MID(SUBSTITUTE(MID($B$2:$B$9,RIGHT(SMALL(FIND(COLUMN($A:$I),$B$2:$B$9&1/17)+$A$2:$A$9/1%,$A$2:$A$9*9-8),2),99),"/",REPT(" ",9)),{1,10},9))*1,10^{1;7})/1%+$A$2:$A$9,ROW(A1)),2),)