201901091456篩選 同格輸入多個編號 (5269)

F2:G7=IFERROR(INDEX(A:A,RIGHT(SMALL(IFERROR(ROW($1:$9)/1%%+MATCH(TRIM(MID(SUBSTITUTE($D$2,",",REPT(" ",29)),ROW($1:$9)*29-28,29))*1,$A:$A,),FALSE),ROW(A1)),4)),"")

J2:J7=IF(I2="","",INDEX(B:B,I2+1)&"")

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





Powered by Xuite