核对括号命令

① excel统计出现频率最高的词（非数字）

在不借助辅助列的情况下有点麻烦，暂时没想到更简便方法，写了个作文公式，先凑合用一下。B9单元格公式=TEXTJOIN(,,,IF(COUNTIF(A$1:C$4,TRIM(MID(SUBSTITUTE(TEXTJOIN(" ",1,IF(MATCH(TRIM(MID(SUBSTITUTE(TEXTJOIN(" ",1,A$1:C$4)," ",REPT(" ",1000)),ROW($1:$999)*1000-999,1000)),TRIM(MID(SUBSTITUTE(TEXTJOIN(" ",1,A$1:C$4)," ",REPT(" ",1000)),ROW($1:$999)*1000-999,1000)),)=ROW($1:$999),TRIM(MID(SUBSTITUTE(TEXTJOIN(" ",1,A$1:C$4)," ",REPT(" ",1000)),ROW($1:$999)*1000-999,1000)),""))," ",REPT(" ",1000)),ROW($1:$999)*1000-999,1000)))=LARGE(COUNTIF(A$1:C$4,TRIM(MID(SUBSTITUTE(TEXTJOIN(" ",1,IF(MATCH(TRIM(MID(SUBSTITUTE(TEXTJOIN(" ",1,A$1:C$4)," ",REPT(" ",1000)),ROW($1:$999)*1000-999,1000)),TRIM(MID(SUBSTITUTE(TEXTJOIN(" ",1,A$1:C$4)," ",REPT(" ",1000)),ROW($1:$999)*1000-999,1000)),)=ROW($1:$999),TRIM(MID(SUBSTITUTE(TEXTJOIN(" ",1,A$1:C$4)," ",REPT(" ",1000)),ROW($1:$999)*1000-999,1000)),""))," ",REPT(" ",1000)),ROW($1:$999)*1000-999,1000))),$A9),TRIM(MID(SUBSTITUTE(TEXTJOIN(" ",1,IF(MATCH(TRIM(MID(SUBSTITUTE(TEXTJOIN(" ",1,A$1:C$4)," ",REPT(" ",1000)),ROW($1:$999)*1000-999,1000)),TRIM(MID(SUBSTITUTE(TEXTJOIN(" ",1,A$1:C$4)," ",REPT(" ",1000)),ROW($1:$999)*1000-999,1000)),)=ROW($1:$999),TRIM(MID(SUBSTITUTE(TEXTJOIN(" ",1,A$1:C$4)," ",REPT(" ",1000)),ROW($1:$999)*1000-999,1000)),""))," ",REPT(" ",1000)),ROW($1:$999)*1000-999,1000)),""))

数组公式， Ctrl+Shift+回车，公式两端出现大括号{}后，下拉。 如图：