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)),"")

    hcm19522 / Xuite日誌 / 回應(0) / 引用(0)
    沒有上一則|日誌首頁|沒有下一則
    回應
      blank