如何在Excel中找到由小功能产生的单元的行数?
我想在Excel列中找到5个最小元素的行(以在另一列中找到每个相关内容,形式示例名称)。我的数据包括一些0个数据(其名称不同)。例如,第一和第二为零。问题是匹配函数返回两个项目的相同行数。例如,如何通过此图片中的匹配和索引功能返回“三月”和“技能”?
I want to find to row number of 5 smallest elements in a excel column (to find related content of each in another column, form example names). My data includes some 0 data (whose names are different). For example first and second are zero. The problem is that match function returns same row numbers of the two items. For example, how to return "March" and "sKill" by match and index function in this picture?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

在 O365 中,您可以使用以下其中一项:
scoreTable
,并使用结构化引用。返回得分最低的五个
=INDEX(SORT(scoreTable,2,1),SEQUENCE(5),1)
返回分数排名最低 5 的任意数量的结果< /em>
=FILTER(scoreTable[名称],scoreTable[分数]<=SMALL(scoreTable[分数],5))
In O365 you can use one of the following:
scoreTable
and am using structured references.To return the five with the lowest scores
=INDEX(SORT(scoreTable,2,1),SEQUENCE(5),1)
To return any number of results whose scores rank in the lowest 5
=FILTER(scoreTable[Name],scoreTable[Score]<=SMALL(scoreTable[Score],5))