Look Who it Was Random video

Excel Rev Up - Filter Search: Episode 1321

997 views · Published 12 January 2011 · 2:00 · Indexed 9 October 2026

Channel: MrExcel.com · 2011 · Education

Watch on YouTube

Microsoft Excel Tutorial: Excel Filter Search: Find and Filter Data Efficiently | MrExcel Podcast.

Welcome back to the MrExcel podcast. In this episode, we're diving into chapter 16 of our Rev Up to Excel 2010 series, where we'll be discussing the powerful filter search feature.

As many of you know, filter by selection is a handy tool that allows you to quickly filter your data by selecting specific criteria. If you haven't set up your version of Excel to do this, be sure to check out episode 1239 of our podcast for a step-by-step guide.

But in this episode, we're taking it a step further and exploring the new search ability in Excel 2010 filter. To demonstrate, I'll go to Data, Filter to turn on the filter and then use the dropdowns to search for all customers containing the word 'bank'. This quickly narrows down my data to just the banks, but I also want to include any companies with the words 'finance' or 'financial'.

Here's where the new search feature comes in. Instead of manually selecting each company, I can simply search for 'Finan' and add the current selection to my filter. This way, I get all the banks and the finance companies in one go. This is a huge time-saver, especially when dealing with large datasets.

Overall, the ability to search within the filter is a game-changer for Excel users. It allows for a more efficient and streamlined way of filtering data, making it easier to find the information you need. Thanks for tuning in to this episode of the MrExcel podcast, and be sure to join us next time for more tips and tricks to help you excel in Excel.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Filter Search 
(00:14) Covering filter by selection 
(00:29) New filter by selection in Excel 2010 
(00:39) Using search in filter 
(01:01) Selecting all search results 
(01:19) Adding current selection to filter 
(01:29) Quick and efficient way to search through large group 
(01:39) Improvement in Excel 2010 filter ability 
(01:49) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Chapter 16
Excel version setup
Filter by selection
Filter Search
Improved filter ability in Excel 2010
New filter by selection
Podcast episode 1239
Search ability in Excel 2010 filter
Searching for specific keywords (e.g., 'bank', 'finance', 'financial')


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153001/


Excel 2010 added a cool new search box to the Filter dropdown. Today, in Episode #1321 of the Learn Excel from MrExcel podcast, Bill looks at filtering by multiple [keyword] searches to display results for an industry.

More from this channel