202110071223排序 數字優先 中文次之 (8930)

E2:F21{=IFERROR(INDEX(B:B,RIGHT(SMALL(IF($C$2:$C$21<>"",IF($C$2:$C$21="補貨中",99,$C$2:$C$21)/1%+ROW($2:$21)),ROW(A1)),2)),"")

另解{=IFERROR(INDEX(B:B,RIGHT(SMALL(IF($C$2:$C$21<>"",TEXT($C$2:$C$21,"0;;;\9\9")/1%+ROW($2:$21)),ROW(A1)),2)),"")

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank