Use the Excel PivotTable function to figure out the number of keywords, and which keywords appear most. For example, there are a list of names with names, and they want to count the names of Zhang San and Lee four.
In the following picture, the key words in this column are "two times".
First select the key word, then click "insert" - "PivotTable".
The next window will be popped up, and the default is OK. Click OK.
The next step is to jump to the new worksheet and drag the keywords into rows and values.
The final effect is very intuitive, you can make them a sort of sorting, you can be able to figure out which word appears the most.