Find all values ​​greater than or equal to some value

Question

Let's say I have the following table.

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

I want all teams to score over 80 in another table. I tried the Index + Match function as follows, but that only gives me the smallest value greater than 80.

Here is the code:

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

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

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

Answer 1

How to use autofilter? Then you flexibly filter the values ​​in the column.

Answer 2

vba,

=if(B2 > 80, A2, "")

. , , , .

Answer 3

(Team ROWS, Score SIGMA VALUES, Sum of Score , ... 80 , : is greater than *, .

* , , is greater than or equal to.

Answer 4

D2 CTRL+SHIFT+ENTER, , .

=INDEX($A$1:$A$11,SMALL(IF($B$2:$B$11>=80,ROW($B$2:$B$11)),ROW(1:1)))

See How to find a value in a list and return a few matching values for parts.