Use Excel PivotTable function to count the number of keywords and which keyword appears the most. For example, there is a table with the title of "Zhang San" and "Li Si" with the same name. In the picture below, how many times do you want to count the word "skirt" in the keyword column?
先选择关键词这一列,然后点击“插入”-“数据透视表”
会弹出下面的窗口,默认就行,直接点击确定
接下来会跳转到新的工作表中,把“关键词”...