202210041540出現數字 提取 (10573)

B11:E21{=IFERROR(INDEX(TRIM(MID(SUBSTITUTE($A11,",",REPT(" ",19)),{1,2,3,4}*19-18,18)),SMALL(IF(COUNTIF($H:$H,TRIM(MID(SUBSTITUTE($A11,",",REPT(" ",19)),{1,2,3,4}*19-18,18)))=1,{1,2,3,4}),COLUMN(A1))),"")

第一數無 0 有誤 {=MID($A11,SMALL(IFERROR(FIND(RIGHT(0&$H$1:$H$22,2),$A11),99),COLUMN(A1)),2)

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