字母類似 分別提取後面數字 (14007)

D3:F7{=IFERROR(RIGHT(SMALL(IF(ISNUMBER(FIND(","&$C3&"-",","&$A$3:$A$6)),IFERROR(MID($A$3:$A$6,FIND(","&$C3&"-",","&$A$3:$A$6)+LEN($C3)+1,COLUMN($A:$E))*1,)+ROW(1:4)*10^9),COLUMN(A1)*5),9)*1,"")



留言