Extract unique list based on criteria

[Lara_1234]

All

I have a table with 2 columns

Name	Amount
a	10​
b	2​
h	15​
a	8​
d	7​
e	4​
f	6​

i want a unique list of name if the amount is less than 9. in above example i am looking for a list list which does not have a,b,d,e,f as all of them are below 9.

 

[ETAF]

if you have 365 version of excel
=SORT(UNIQUE(FILTER(A2:B8,B2:B8<9)),2)
sorted by value

BUT you say Unique list if LESS than 9 - BUT then say you dont want a,b,d,e,f, because they are less than 9 ? confused do you want a list that is less than 9 or more than 9

A has an entry 8 and an entry 10 - so less and more than 9

=SORT(UNIQUE(FILTER(A2:B8,B2:B8>9)),2)
still includes A as you have an entry of 10 in the list

or is it the SUM of the letters you need to consider ?