数据提取问题

leepoison

sunsing 发表于 2024-8-26 07:52
老师，我前面理解错误了，附件中情况已经是我们转产的极限，请老师帮忙在2.0附件中指点

你的A18开始，前面多了空格。加个TRIM

=DROP(REDUCE("",A4:A106,LAMBDA(x,y,VSTACK(x,VSTACK(IFNA(HSTACK(--LEFT(TRIM(y),2),IFNA(HSTACK(OFFSET(y,,1),1/TOCOL(1/(VSTACK(IFERROR(TOCOL(OFFSET(y,,4,,20),3),""),REPTARRAY(FILTER($BQ$5:$BQ$12,$BP$5:$BP$12=OFFSET(y,,1)),OFFSET(y,,2)-OFFSET(y,,3)))),3)),OFFSET(y,,1))),--LEFT(TRIM(y),2)))))),1)

sunsing

leepoison 发表于 2024-8-26 19:32
你的A18开始，前面多了空格。加个TRIM

=DROP(REDUCE("",A4:A106,LAMBDA(x,y,VSTACK(x,VSTACK(IFNA(H ...

感谢老师指点，已经完美解决了