如何在Google表格中找到第二最常见的值? [英] How do I find the second most frequent value in Google sheet?
问题描述
我是使用= MODE(B1:F85)来获得模式,我怎样才能得到哪个是10之后的第二个最频繁的值?
谢谢
这应该返回第二个最频繁的值:
= ArrayFormula(MODE(IF((B1:F85 = MODE(B1:F85)),,B1:F85)))
另外,我认为你需要在第二个参数中使用,而不是完全省略参数,在我看来)一个低级的bug,我会报告。尽管如此,即使行为发生了相应的变化,上述公式仍然可以正常工作。
I am using =MODE(B1:F85) to get the MODE, how do I get which is the second most frequent value after 10? Thanks
This should return the second most frequent value:
=ArrayFormula(MODE(IF((B1:F85=MODE(B1:F85)),"",B1:F85)))
As an aside, I think the fact you need to use "" in the second argument, rather than omitting the argument altogether, is (in my opinion) a low-grade bug, which I will report. Nevertheless, the above formula should still work even if the behaviour was changed accordingly.
这篇关于如何在Google表格中找到第二最常见的值?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!