#1
|
|||
|
|||
How to search for multiple words in a random order?
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!! |
#2
|
|||
|
|||
Label filters? Is this about filtering the Pivot Table?
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
search and highlight multiple words in doc | sknanda | Word VBA | 8 | 02-17-2020 12:20 AM |
Help creating VBA code to search multiple word documents for specific group of words | dmreno | Word VBA | 3 | 07-30-2019 02:31 PM |
Several Custom Shows in Random Order | excelledsoftware | PowerPoint | 1 | 09-27-2014 09:50 PM |
Multiple words, one search | return2300 | Word VBA | 0 | 08-30-2013 12:26 PM |
list of documents come up in random order - any ideas how to sort this? | tallscot49 | Word | 0 | 07-18-2010 12:40 AM |