指定行合并

15968725770

指定行合并

指定行合并

hugeinfo

上附件！            

15968725770

hugeinfo 发表于 2024-11-25 13:55
上附件！

谢谢老师帮忙弄下

hxj119

建议去VBA版块

15968725770

hxj119 发表于 2024-11-25 14:34
建议去VBA版块

可以的老师

hugeinfo

=DROP(LET(b,OFFSET(E5,C23,,D23-C23+1,4),GROUPBY(TAKE(b,,1),DROP(b,,1),HSTACK(LAMBDA(a,TEXTJOIN("/",,a)),SUM,SUM),,0)),1)


或者
=DROP(LET(b,OFFSET(E5,C23,,D23-C23+1,4),GROUPBY(TAKE(b,,1),DROP(b,,1),HSTACK(LAMBDA(a,"38*3.5*"&TEXTJOIN("/",,SUBSTITUTE(a,"38*3.5*",""))),SUM,SUM),,0)),1)

zwzc

=DROP(GROUPBY(E6:E20,F6:H20,HSTACK(LAMBDA(a,TEXTJOIN("*",,LET(t,TEXTSPLIT(TEXTJOIN("+",,a),"*","+"),GROUPBY(DROP(t,,-1),DROP(t,,2),LAMBDA(x,TEXTJOIN("/",,x)),0,0)))),SUM,SUM),0,0,,(A6:A20>=C23)*(A6:A20<=D23)),1)

你是那块小饼干

1. =LET(T,FILTER($E$6:$H$20,($A$6:$A$20>=$C$23)*($A$6:$A$20<=$D$23)),HSTACK(UNIQUE(CHOOSECOLS(T,1)),TEXTJOIN("/",TRUE,TAKE(CHOOSECOLS(T,2),1),TEXTAFTER(DROP(CHOOSECOLS(T,2),1),"*",2)),SUM(CHOOSECOLS(T,3)),SUM(CHOOSECOLS(T,4))))

复制代码

忙到飞起

=LET(a,CHOOSEROWS(E6:H20,SEQUENCE(D23,,C23)),HSTACK(TAKE(TAKE(a,1),,1),TEXTJOIN("/",,TAKE(CHOOSECOLS(a,2),1),TEXTAFTER(DROP(CHOOSECOLS(a,2),1),"*",-1)),TOCOL(TAKE(a,,-1),1)))
写的不好

15968725770

各位老师弄个附件，谢谢