网页资讯视频图片知道文库贴吧地图采购
进入贴吧全吧搜索
excel吧 关注：280,821贴子：1,542,994
  • 31回复贴，共1页

用一条函数公式出黄色区域结果

链接: https://pan.baidu.com/s/11t4lAHavhVC8cxFemXTnuA?pwd=ragb 提取码: ragb 复制这段内容后打开百度网盘手机App，操作更方便哦


WPS365夏季更新版：
=LET(a,TEXTJOIN("，",,A3:A9),s,REGEXP(a,"\D+"),y,REGEXP(a,"\d+"),x,UNIQUE(TOCOL(SUBSTITUTE(s,"，",))),p,SUBSTITUTE(VSTACK(s,y),"，",),HSTACK(x,MAP(x,LAMBDA(o,SUM((TAKE(p,1)=o)*(TAKE(p,-1)))))))




=LET(p,TEXTSPLIT(TEXTJOIN("，",,A3:A9),,"，"),q,TEXTBEFORE(p,ROW(1:10)-1),s,--SUBSTITUTE(p,q,),t,UNIQUE(q),HSTACK(t,MMULT(N(TRANSPOSE(q)=t),s)))


=LET(x,CONCAT(A3:A9),y,REGEXP(x,"[一-龢]+"),z,UNIQUE(TOCOL(y)),HSTACK(z,MAP(z,LAMBDA(m,SUM(FILTER(--REGEXP(x,"[\d.]+"),y=m))))))


=LET(a,WRAPCOLS(REGEXP(CONCAT(A3:A9),"[^，\d]+|\d+"),2),b,TAKE(a,1),c,TOCOL(UNIQUE(b,1)),HSTACK(c,BYROW((b=c)*DROP(a,1),SUM)))


=LET(z,CONCAT(A3:A9&"，"),a,TEXTSPLIT(z,ROW(1:10)-1,"，",1),b,TEXTSPLIT(z,a,"，",1),UNIQUE(HSTACK(a,MAP(a,LAMBDA(x,SUM((a=x)*b))))))



=LET(z,CONCAT(A3:A9&"，"),a,TEXTSPLIT(z,VSTACK(ROW(1:10)-1,"，"),,1),b,TEXTSPLIT(z,HSTACK(a,"，"),,1),c,TOCOL(UNIQUE(a,1)),HSTACK(c,MMULT((a=c)*b,--TOCOL(a>0))))


没看见有不合并写法


扫二维码下载贴吧客户端

下载贴吧APP
看高清直播、视频！
  • 31回复贴，共1页
分享到: