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

我的城市你来过

2023.03.23相同值销量排序统计

=IFERROR(CONCAT(CONCAT(IF(ISNUMBER(FIND(LARGE(SUMIFS($B$3:$B$15,$A$3:$A$15,INDEX(UNIQUE($A$3:$A$15,FALSE,FALSE),,ROW($A$1:$A$6))),ROW(A1)),SUMIFS($B$3:$B$15,$A$3:$A$15,INDEX(UNIQUE($A$3:$A$15,FALSE,FALSE),,ROW($A$1:$A$6))))),INDEX(UNIQUE($A$3:$A$15,FALSE,FALSE),,ROW($A$1:$A$6)),"")),"销量",LARGE(SUMIFS($B$3:$B$15,$A$3:$A$15,INDEX(UNIQUE($A$3:$A$15,FALSE,FALSE),,ROW($A$1:$A$6))),ROW(A1))),"")

我的城市你来过

2023.03.23重复登记核对
=IF(MATCH($A$2:$A$36&$B$2:$B$36&$C$2:$C$36&$D$2:$D$36,$A$2:$A$36&$B$2:$B$36&$C$2:$C$36&$D$2:$D$36,)=ROW($A$1:$A$35),INDEX(Sheet1!$D$2:$D$42,MATCH($B$2:$B$36&$C$2:$C$36,Sheet1!$B$2:$B$42&Sheet1!$C$2:$C$42,),),"错误")

我的城市你来过

2023.03.24条件统计取值

=SUM(IFERROR(FIND(A22,IF(COUNTIFS(数据!$B$1:$B$725,数据!$B$1:$B$725)>=4,数据!$C$1:$C$725)),""))

我的城市你来过

2023.03.28销量汇总统计
=COUNT(IF(SUMIFS($B$2:$B$8,$A$2:$A$8,IF(COUNTIF(INDIRECT("$A$2:$A"&ROW($A$2:$A$8)),$A$2:$A$8)=1,$A$2:$A$8,""))={2,3},1,0))

我的城市你来过

2023.03.29合并单元格内容
=IFNA(INDEX($A$2:$AY$2,,LOOKUP(COLUMN($A$2:$AY$2),IF($A$2:$AY$2<>"",COLUMN($A$2:$AY$2),"")))&INDEX($A$3:$AY$3,,LOOKUP(COLUMN($A$3:$AY$3),IF($A$3:$AY$3<>"",COLUMN($A$3:$AY$3),"")))&$A$4:$AY$4,$A$2:$AY$2)

我的城市你来过

2023.03.29提取单元格内最大日期
=TEXT(MAX(MID(A2,UNIQUE(SEARCH("????-??-??",A2,ROW(INDIRECT("$A$1:$A"&SUM(LEN(A2)-9))))),10)*1),"yyyy-mm-dd")

我的城市你来过

2023.03.20倒序抵消
=IF(C3,MIN(C3,$B3-SUM(H3:J3)),)

我的城市你来过

2023.04.03合并单元格条件求和

=SUM(SUMIFS(B$2:B$16,$A$2:$A$16,IF(LOOKUP(ROW($A$1:$A$15),MATCH($G$2:$G$16,$G$2:$G$16,))+1=MATCH($A21,$G$2:$G$16,)+1,$H$2:$H$16,"")))

我的城市你来过

2023.04.11汉字转拼音
=CONCAT(LEFT(TRIM(MID(SUBSTITUTE(GetPinyin(A2)," ",REPT(" ",66)),ROW($A$1:$A$3)*66-65,66)),1))

我的城市你来过

2023.04.14数字转化模拟
=CONCAT(SUBSTITUTE(SUBSTITUTE(REPT(UNIQUE(MID(B2,ROW($A$1:$A$3),1)),2),{0,1,2,3,4,5,6,7,8,9},{5,6,7,8,9,0,1,2,3,4},1+(UNIQUE(MID(B2,ROW($A$1:$A$3),1))*1<=5)),REPT(UNIQUE(MID(B2,ROW($A$1:$A$3),1)),2),""))

对码：0-5；1-6；2-7；3-8；4-9