日期和数量分开提取

Tongbaby2020 · 发表于 2024-4-25 11:58

日期和数量拆分提取，大神看看！

edwin11891 · 发表于 2024-4-25 14:19

本帖最后由 edwin11891 于 2024-4-25 14:31 编辑

365函数，新版WPS可用：

=REDUCE({"系列","发货日期","拆分","发货数量"},A2:A4,LAMBDA(x,y,VSTACK(x,IFNA(HSTACK(IFNA(HSTACK(y,--TEXTSPLIT(SUBSTITUTE(OFFSET(y,,1),"pcs",""),":"," ")),y),OFFSET(y,,2)),OFFSET(y,,2)))))

复制代码

hcm19522 · 发表于 2024-4-25 14:24

本帖最后由 hcm19522 于 2024-4-25 14:26 编辑

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})))

		自动登录	找回密码
密码			免费注册

[已解决] 日期和数量分开提取

评分

评分