• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract unique list based on criteria

Lara_1234

New Member
All

I have a table with 2 columns

NameAmount
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.
 
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 ?
 

Attachments

  • unique under 9 -ETAF.xlsx
    9.7 KB · Views: 1
Back
Top