Google 表格中最常见的文本值问题不会出现多次

发布于 2025-01-09 19:30:34 字数 391 浏览 0 评论 0原文

我在获取最常见的值时遇到一些问题，我正在使用下一个有效的公式：

=INDEX(A1:A9,MODE(IF((A1:A9<>"")*ISNA(MATCH(A1:A9,$B$1:$B1,0)),MATCH(A1:A9,A1:A9,0))))

但在某些列中，数据显示如下：

值未出现时出现错误我不止一次想补充一些条件，但我一直在尝试使用不同的公式，但没有得到更好的结果，请问我可以使用一些建议或公式吗？

原文

I'm having some problems getting the most frequent value I'm using a formula that works is the next one:

=INDEX(A1:A9,MODE(IF((A1:A9<>"")*ISNA(MATCH(A1:A9,$B$1:$B1,0)),MATCH(A1:A9,A1:A9,0))))

But in some column the data appears like this:

An error when the value is not occurring more than once I would like to add some condition but I've been trying with different formulas and I did't get better results some advices or formulas that I could use please?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

瑶笙 2025-01-16 19:30:34

每列：

=INDEX(QUERY(A1:A9, 
 "select A,count(A) where A is not null group by A order by count(A) desc"), 2, 1)

每范围：

=INDEX(QUERY(FLATTEN(A1:G9), 
"select Col1,count(Col1) where Col1 is not null group by Col1 order by count(Col1) desc"), 2, 1)

per column:

=INDEX(QUERY(A1:A9, 
 "select A,count(A) where A is not null group by A order by count(A) desc"), 2, 1)

per range:

=INDEX(QUERY(FLATTEN(A1:G9), 
"select Col1,count(Col1) where Col1 is not null group by Col1 order by count(Col1) desc"), 2, 1)

回复收藏 0 原文

往昔成烟 2025-01-16 19:30:34

您还可以使用以下公式：

=ARRAYFORMULA(INDEX(A1:A10,MATCH(MAX(COUNTIF(A1:A10,A1:A10)),COUNTIF(A1:A10,A1:A10),0)))

然后将其拖过行：

用于此目的的值得注意的函数如下：

COUNTIF 它将返回流行数字出现次数；
MATCH 以匹配主要选择；
ARRAYFORMULA，它可以将从数组公式返回的值显示为多行和/或多列，以及将非数组函数与数组一起使用。

参考

You can also the formula below:

=ARRAYFORMULA(INDEX(A1:A10,MATCH(MAX(COUNTIF(A1:A10,A1:A10)),COUNTIF(A1:A10,A1:A10),0)))

And later drag it across the row:

The notable functions used for this are the following:

COUNTIF which will return the prevalent number of occurrences;
MATCH in order to match the predominant choice;
ARRAYFORMULA which enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays.

Reference

回复收藏 0 原文

~没有更多了~