Unique

Lucasvital

Hi,

I have a list of 400 names that can be non-exclusively A, B, C or D. So:

Names	Category
Name 1	A
Name 2	A
Name 2	B
Name 2	D
Name 3	B
Name 4	C
Name 4	D
Name 5	D
Name 6	A
Name 6	D

I want select/filter a list of all names that contains only C and D... Don't Contain A, or B. In the example above would be Names 4 and 5. I am basically looking for a filter function with more than two criterias (e.g. Contains C OR Contains D AND does not contain A and .

Any suggestion?

danilang

Hi @Lucasvital 

Here's a completely different way to do it

Concatenate the categories by name and then apply a multipart filter

Contains([Concat_Category],"C") or Contains([Concat_Category],"D") and 
!(Contains([Concat_Category],"A") or Contains([Concat_Category],"B"))

resulting in 

Also, this is just a hunch, but is your input data is already some kind of concatenated format and did you parse this input to rows to generate the table that you show in your post above?  If that's the case, just use the filter directly on your input.

Dan  

Unique.yxmd