Excel-提取前5个值 [英] Excel - extracting top 5 values
问题描述
我想根据每位员工的销售额(没有数据透视表/自动过滤器)提取前5名球员.
I would like to extract the top 5 players based on the sales by each employee (without Pivot Table / Auto filter).
请参阅我的输入和输出屏幕截图
Refer my input and output screenshot
任何建议,如何获得前5名(即使重复;如屏幕截图所示)
Any suggestions, how to obtain first top 5 ranks (even if repeated; as shown in the screenshots)
我已验证提取顶部不包含VBA的列表中每个组的5个值以及其他一些链接.
I have verified Extract Top 5 Values for Each Group in a List without VBA and some other links also.
提前感谢您的时间和考虑!如果我的要求不清楚和/或您有任何具体问题,请告诉我.
Thanks in advance for your time and consideration! Please let me know if my request is unclear and/or if you have any specific questions.
推荐答案
这是我用来追踪前5位缺席者的方法... 编辑以适合您的需求.
This is what I use to track the top 5 absentees... Edit to suit your needs.
单元格A1中的公式:
=INDEX(A$13:A52,AGGREGATE(15,6,ROW($1:$40)/(B$13:B$52=B1),COUNTIF(B$1:B1,B1)))
单元格B1中的公式: 大(B $ 13:B $ 52,ROW())
Formula in cell B1: LARGE(B$13:B$52,ROW())
这篇关于Excel-提取前5个值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!