How to search for multiple words in a random order?

[ceaser333]

Hi


So I'm trying to filter my data by using label filters. However, in my cell I have multiple values that belong to one category. For example, for the category fruit, my cell would contain apple, orange, bananas.

The issue is that when I try searching for all cells that contain some of these fruit types (like apple and bananas) it does not give me the right results. I think it's because I'm not seatching in the exact order that it is in but I'm not sure.E.g. when I search *apple* *orange* *banana* it works and displays the cell containing apple, orange, bananas.However, if I search *apple* *bananas* it does not display this option.

Is there any way to fix this so it also displays the option apple, orange, bananas? I feel like it's probably an easy fix but I can't seem to figure it out. If there is an alternative way of doing this (without VBA) I'd also love to know!!

[ArviLaanemets]

Label filters? Is this about filtering the Pivot Table?