有没有办法使这种类型的查询工作? [英] Is there a way to make this type of query work?
本文介绍了有没有办法使这种类型的查询工作?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
= query(G2:I80,select G,H,I where H = max(H)group by I, - 1)
Columnn G is名称
列H是投票计数和
列I是他们各自的团队。
我想查看每个团队的顶级投票名称,有时一些顶级的投票人姓名是绑定的,所以我想使用上面的查询查看这两个名字,但它似乎不工作。
我不完全确定你想要什么(一个不起作用的公式不是一个好的指南),但也许:
= sort(过滤器(查询(G2:I80,选择G,H,I,-1),H2:H80 =最大(H:H)),3,TRUE)
pre>
=query(G2:I80,"select G,H,I where H=max(H) group by I",-1)
Columnn G is names Column H is vote count and Column I is Their respective teams.
I want to view the top voted names of each team and sometimes the some top voted names are tied so I wanna view both names using the query above but it dont seem to work.
解决方案I am not entirely sure what you want (a formula that does not work is not a good guide) but perhaps:
=sort(filter(query(G2:I80,"select G, H, I ",-1),H2:H80=Max(H:H)),3,TRUE)
这篇关于有没有办法使这种类型的查询工作?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!