Trying to create a filter to exclude 2 specific values

[Giuseppe D'Amaro]

I have a list of variables, that can exist alone or together:

Apple, Pear, Orange, Banana, Ice Cream

I want a filter that looks for all the above variables EXCEPT Ice cream. And if Ice Cream and Banana are together, then I want that EXCLUDED also.

At the moment I'm using:

....AND platform in (Apple, Pear, Orange, Banana)

Which is filtering out Ice Cream (great), however whenever Banana and Ice Cream come along together, I can't find a way to filter that out.

Hope someone can help, thanks

[Payne]

Try

platform != "Ice Cream"

[Giuseppe D'Amaro]

Thanks Payne, but I want issues that just have Ice Cream. It's when it's Ice and Banana, that I'm trying to exclude