从一定范围内选取前 5 个分数
我用 excel 经营着一家小型高尔夫折衷主义公司。 我们拥有的东西之一是积分系统。 我想获得整个赛季的 5 个最高分，并将它们从 1（最高分）到 5 进行排名。
我对 excel“求和”的了解只比加法和减法稍深一点。
谢谢！
I run a small golf eclectic with excel. One of the things we have is a points system. I would like to get the 5 highest points scored over the season and have them ranked from 1 (being the highest points scored) to 5.
My knowledge of excel "sums" goes only a wee bit further than add and subtract.
Thanks!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
如果您不想更改它们当前的顺序，可以使用 LARGE 函数。 它返回第 k 个最大值。
下面是一个很棒的公式，如果你向下拖动它，它会自动从数据表中获取第二、第三和第 n 个最大值（在本例中，数据在 A1 到 A10 之间）。
然后，您可以使用 MATCH 和 INDEX 函数将值与表中的名称或相应数据进行匹配。 下面的示例将从第二列中获取每个值的名称。
尝试一下这些公式，它们对于数据m非常方便
If you don't want to change the order that they are presently in you can use the LARGE function. It returns the kth largest value.
Below is a great formula, if you drag it down it will automatically get the second, third and nth largest value from a table of data (in this example the data is between A1 to A10).
You can then match the values with names or corresponding data from the tables using the MATCH and INDEX functions. The example below would fetch the name for each value from the second column.
Play around with these formulas, they are very convenient for data m
如果您有一列包含分数，您可以添加一个过滤器（我认为数据->过滤器）并按降序排序。
不过，如果您只有类似于 [日期][人员][分数] 的行，您需要转到另一张表并对每个人的分数求和，然后对其进行排序...不幸的是，我的 Excel 技能还没有提高像这样为每个人拉出一个分数。
If you have a column containing the scores, you could add a filter (Data->Filter I think) and sort descending.
Though, if you just have rows that are something like [Date][Person][Score] you'll need to go to another sheet and SUM the scores for each person then sort that... Unfortunately my Excel skills aren't up to par to pull a score for each person like that.
给定 A1 到 A10 中的数字列表，您可以使用“RANK”计算出它们相对于彼此的“排名”。
例如
RANK（单元格、要检查的单元格列表、顺序）
对于顺序，0 = 降序。
从那里你可以实用地找出哪个是第一个。
Given a list of numbers in A1 to A10, you can work out their 'Rank' relative to each other by using 'RANK'.
e.g.
RANK(cell, list of cells to check against, order)
For order, 0 = descending.
From there you can work out which one is first pragmatically.
如果您使用的是 Excel 2007，
请检查您的数据是否连续，没有空白行或列。 点击您的分数，然后选择“数据 - 过滤器”
使用过滤器在分数列顶部创建的下拉列表，然后选择“数字过滤器 - 前十名”
A将显示“前十个自动过滤器”对话框，将显示的10个减少到5个，然后单击“确定”。
对于早期版本的 Excel，在新列中添加 RANK 公式。 请小心，因为分数需要排序，通常是降序排列。 如果有平局，则给予相同的排名号码，随后的排名号码将按平局数递增。 （例如，如果有两个分数为2，则排名为5。下一个分数将排名为7，而不是6）
If you have Excel 2007,
Check that your data is continuous, with no blank rows or columns. Click on your scores and then select 'Data - Filter'
Using the dropdown that the filter creates at the top of your scores column and select 'Number filters - Top ten'
A 'Top ten Autofilter' dialog will be displayed, reduce the show 10 to 5 and then click on OK.
For earlier versions of Excel add a RANK formula in a new column. Be careful as the scores need to be sorted, usually into descending order. If there are any ties, they will be given the same ranking number and the subsequent rank number will be incremented by the number of ties. (E.g. If there are two scores of 2, ranked as 5. The next score will be ranked as 7, not 6)
如果您想如上所述使用 LARGE 函数，请确保在列表中为每个 LARGE 函数放置相同的范围。 即，将 =LARGE(A1:A10,ROW(A1)-ROW($A$1)+1) 更改为 =LARGE(A$1:A$10,ROW(A1)-ROW($A$1)+1) 或你会得到一些奇怪的错误结果
If you want to use the LARGE Function as described above, make sure you put the same range in the list for each of the LARGE functions. That is, change =LARGE(A1:A10,ROW(A1)-ROW($A$1)+1) to =LARGE(A$1:A$10,ROW(A1)-ROW($A$1)+1) or you will get some strange incorrect results