核對括弧命令

① 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+回車，公式兩端出現大括弧{}後，下拉。 如圖：