求解使用EXCEL统计出地址中的高频词（E高手请进）

我的城市你来过

20240412相同数编码
=LET(x,1/(COUNTIFS(B$2:B2,B2,C$2:C2,C2)/SUM(IF(C$2:C2=C2,1,0))),IF(x>2,x-1,x))

=SUM(IF(C$2:C2=C2,1/COUNTIFS(B$2:B2,B$2:B2,C$2:C2,C$2:C2)),0)

我的城市你来过

20240502替换练习
=CONCAT(LET(x,MID($B2,ROW(INDIRECT("a1:a"&LEN($B2))),1),IFERROR(CHOOSE(x,44,21,42,35,24,5,2),x)))

我的城市你来过

20240525正则查找

=FILTER($A$12:$A$15,MMULT(--IFERROR(REGEXP($B2,$B$12:$C$15,1),0),{1;1})=1)

我的城市你来过

20240528数值匹配
=SUM(FILTER($F$2:$F$13,"@"=MAP($E$2:$E$13,LAMBDA(x,SUBSTITUTES(x,TOROW(A2&"."&TEXTSPLIT(B2,"|"))*1,"@"))),0))

我的城市你来过

20240609相反数随机取3
1. B1：B3随机提取A1:A26数值，并且提取的数值不重复
2. IF B1:B3=1 3 5 6 8 10 12 22 26(不规则数组）时，则返回剩余其他数值
=LET(x,FILTER($A$1:$A$26,BYROW(IF($A$1:$A$26-{1,3,5,6,8,10,12,22,26}=0,"",$A$1:$A$26),SUM)/$A$1:$A$26=9),TAKE(SORTBY(x,RANDARRAY(x),1),3))

我的城市你来过

问题Q：热词高频词分析？

=LET(b,SORT(DROP(LET(a,MID(CONCAT(REGEXP($B$5:$D$5,"[一-龟]+")),SEQUENCE(LEN(CONCAT($B$5:$D$5)),,1),2),REDUCE("",UNIQUE(a),LAMBDA(x,y,VSTACK(x,HSTACK(y,BYROW(TOROW(FILTER(a,a=y)),COUNTA)))))),1),2,-1),TEXTJOIN("、",,IF(DROP(b,,1)>=2,DROP(b,,-1),"")))

mjm04

正则表达式拆分出来再统计

我的城市你来过

=LET(a,REGEXP(INDEX($J$3:$J$5,MATCH(A3,{"B","C","A"},0)),"(?<=首重)\d+")*1,IFS(a=1,$F3+MIN(($E3-1)*$G3,29*$G3)+(MAX(($E3-30)*$H3,0)),a=20,$F3+MIN(($E3-20)*$G3,40*$G3)+(MAX(($E3-60)*$H3,0)),a=60,$F3+MAX(($E3-60)*$G3,0)))


=IFS($A3="A",$F3+MIN(($E3-1)*$G3,29*$G3)+(MAX(($E3-30)*$H3,0)),$A3="B",$F3+MIN(($E3-20)*$G3,40*$G3)+(MAX(($E3-60)*$H3,0)),$A3="C",$F3+MAX(($E3-60)*$G3,0))