Filter data with multiple search terms using

wheatley

New Member
Joined
May 9, 2020
Messages
15
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Hello,

When using filters, how can I add only search terms but for multiple searches. Eg: in the screen capture, I am trying to have the list show only 'Blue circle' and 'Green square'.

demo.gif


I know this can be done with the conditional text filters but I want to just be able to quickly do it from the main filter list.

Thanks.
 
Aha! Got that working (on my Windows machines at least,
Good news (half at least). :)

I tend to use this handy little utility 'LiceCAP' for quick easy GIF screen caps. I was able to drag the gif straight to the post editor here).
I will have a look at that utility, thanks. I could also have put the gif directly in my post but I actually don't much like looking at forum threads/posts/avatars that move all the time. So I deliberately put it elsewhere so that readers can choose whether or not to look at it. 😎
 
Upvote 0

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
No problem.
BTW, I like the look of LiceCAP so thanks for that suggestion. (y)
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,182
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top