查找大于或等于某个值的所有值 [英] Find all values greater or equal than a certain value

问题描述

假设我有下表。

Team Score
AA   81
BB   67
CC   44
DD   1.5
JJ   279
LL   49
TT   201
GG   158
MM   32
HH   89

我想让所有在另一张桌子上得分超过80的球队。我尝试了Index + Match函数如下，但它只给出了大于80的最小值。

I want to get all teams that scored more than 80 in another table. I tried the Index + Match function as follows but it only gives me the smallest value greater than 80.

这里是代码：

=INDEX($A$2:$A$11,MATCH(80,$B$2:$B$11,-1))

尽管我将值放在lookup_array参数中降序，但这个函数只给出一个答案：最小值大于80.

Although I put the values in the lookup_array argument in descending order, this function only gives me one answer: The smallest value greater than 80.

我试图做到这一点，而不必排序数组，并拥有一个庞大的数据库。谢谢。

I am trying to do this without having to sort the array and with a huge database mind you. Thank you.

推荐答案

如何使用AutoFilter？然后，您可以灵活地筛选列分数中的值。

How about using an AutoFilter? You're then quite flexible in filtering for values in column score.

这篇关于查找大于或等于某个值的所有值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！