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

我的城市你来过

20240309合并单元格合并内容
=TEXTJOIN("、",,SUBSTITUTE(IF(CHOOSEROWS($A$1:$A$171,LOOKUP(ROW($A$2:$A$171),IF($A$2:$A$171<>"",ROW($A$2:$A$171),"")))=INDEX(DROP(SORT(UNIQUE($A$2:$A$171)),1),ROW(A1)),$B$2:$B$171,""),0,""))

我的城市你来过

20240309字母排序
=DROP(SORT(UNIQUE(IF(LEFT(SORT(TOCOL(TRIM($A$1:$B$4),)),1)=CHAR(64+COLUMN(A$1)),SORT(TOCOL(TRIM($A$1:$B$4),)),""))),1)

我的城市你来过

20240309得出销冠月
=TEXT(EOMONTH("2013/1",INDEX(SORTBY(ROW(A1:A24),MMULT(TRANSPOSE(--((MONTH(B2:B400)+(YEAR(B2:B400)=2014)*12)=COLUMN(A1:X1))),C2:C400),-1),1)-1),"emm")

我的城市你来过

20240309统计数字排序汇总

=IF(N$16="数值",TOCOL(SORTBY($N$3:$W$3,OFFSET($N$3:$W$3,ROUNDUP(COLUMN(A1)/2,0),),-1)),TOCOL(SORTBY(OFFSET($N$3:$W$3,ROUNDUP(COLUMN(A1)/2,0),),OFFSET($N$3:$W$3,ROUNDUP(COLUMN(A1)/2,0),),-1)))

=COUNT(0/($A$1:$J$67&$A$2:$J$68=N$3&$M4))

我的城市你来过

20240310汇总各项累计数据
=IFERROR(1/(1/EXPAND(MMULT(ISNUMBER(IF(IF($C$2:$C$18=TOROW(UNIQUE($C$2:$C$18)),ROW($C$2:$C$18),"")<TOROW(XMATCH(UNIQUE($C$2:$C$18),$C$2:$C$18,-1,-1)+1),"",IF($C$2:$C$18=TOROW(UNIQUE($C$2:$C$18)),ROW($C$2:$C$18),"")))*TOROW(SUMIFS($F$2:$F$18,$C$2:$C$18,UNIQUE($C$2:$C$18))),ROW(INDIRECT("a1:a"&COUNTA(UNIQUE($C$2:$C$18))))^0),ROWS($C$2:$C$18)+1,,SUM($F$2:$F$18))),"")


=EXPAND(IFERROR(1/1/MMULT(IFERROR(FIND(TRANSPOSE(SUMIFS($F$2:$F$18,$C$2:$C$18,UNIQUE($C$2:$C$18))),SUMIF(INDIRECT("C2:C"&ROW($C$2:$C$18)),$C$2:$C$18,$F$2:$F$18)*($C$2:$C$18=TRANSPOSE(UNIQUE($C$2:$C$18)))),0),ROW(INDIRECT("a1:a"&COUNTA(UNIQUE($C$2:$C$18))))^0)*SUMIF(INDIRECT("C2:C"&ROW($C$2:$C$18)),$C$2:$C$18,$F$2:$F$18),""),ROWS($C$2:$C$18)+1,,SUM($F$2:$F$18))

我的城市你来过

20240310产品系数排名
=SUM(--(B3<FILTER($B$2:$B$68,$A$2:$A$68=$A3)))+1

我的城市你来过

20240310一行数得出其相邻数
=TOROW(SUBSTITUTE(SORT(UNIQUE(TEXT(HSTACK($B4:$G4-1,$B4:$G4+1),"[>0!]"),-1)*1,,,-1),34,""),3)

我的城市你来过

20240310凑数游戏
7个数递减6%，求和为50的数
=RANDARRAY(9999,1,ROUNDUP(50/7+1,1),ROUNDUP(50/7+1,0),FALSE)

=IF((LAMBDA(x,SUM(x*0.94^(ROW($A$1:$A$7)-1)))(A1)<50)*(50-LAMBDA(x,SUM(x*0.94^(ROW($A$1:$A$7)-1)))(A1)<0.01),A1,"")

我的城市你来过

20240314正负区间
=LAMBDA(x,CHOOSE(SUM(FREQUENCY(x,{-250,-50,0,200,9999})*ROW($A$1:$A$6)),-100,(x+50)*0.5,0,x*0.5,100))(B3)

我的城市你来过

20240315生成随机数组
=FREQUENCY(ROW(INDIRECT("1:"&RANDBETWEEN(30,70))),RANDBETWEEN(ROW(1:48)^0,RANDBETWEEN(30,70)))

49个数字随机整数，和值在30-70间