F2:H8{=INDEX(A:A,SMALL(IF(LEN($B$2:$B$4)-LEN(SUBSTITUTE($B$2:$B$4,":",))>={1,2,3,4},ROW($2:$4),99),ROW(A1)))&""
G列改=IF(F2="","",-LOOKUP(1,-LEFT(TRIM(MID(SUBSTITUTE(VLOOKUP(F2,A:C,2,)," ",REPT(" ",99)),COUNTIF(F$2:F2,F2)*99-98,99)),{8,9,10})))
I2=IF(F2="","",-LOOKUP(1,-RIGHT(SUBSTITUTE(TRIM(MID(SUBSTITUTE(VLOOKUP(F2,A:C,2,)," ",REPT(" ",99)),COUNTIF(F$2:F2,F2)*99-98,99)),"pcs",),{1,2,3,4})))
留言
張貼留言