VBA查找列中出现的最大单词及其数量 [英] VBA to find the largest occurring word in the column and its count

问题描述

在"L"列中，我有9个单词多次出现，总共54行.

In column "L" I have 9 words occurring multiple times, in a total of 54 rows.

我的问题是:

我需要最大出现次数和出现次数的单词作为输出.由于我无法附加文件，因此提供了excel的屏幕截图:

I need as output the word that occurred the maximum number of times and the count of occurrences as well. Since I can't attach the file I have provided a screenshot of the excel:

根据屏幕截图:

• Output1将为高清
• Output2将为5

推荐答案

使用CSE尝试使用此数组公式，

Try this array formula with CSE,

=index(l2:index(l:l, match("zzz", l:l)), mode(match(l2:index(l:l, match("zzz", l:l)), l2:index(l:l, match("zzz", l:l)), 0)))

如果您想让VBA查看

If you stll want VBA look at Excel VBA: Getting the 10 Top most frequent name in a column

这篇关于VBA查找列中出现的最大单词及其数量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！