Excel Invoice Filter: Filter to 27 Invoices - Episode 2175
3,473 views · Published 15 November 2017 · 2:53 · Indexed 10 November 2026
Channel: MrExcel.com · 2017 · Education
Microsoft Excel Tutorial: How can I filter to 27 specific invoice numbers? Welcome back to another episode of the MrExcel netcast! In this episode, we will be tackling a question from Tad, who I met at my Power Excel seminar in Springfield, Illinois. Tad has a large dataset with 15,000 rows and needs to filter it down to just 27 specific invoice numbers. As you can imagine, this task can be quite tedious and time-consuming. But fear not, because I have a solution that will save you a lot of time and effort. First, we will show you the traditional method of filtering one by one or searching for each invoice, which can be a real headache. But don't worry, we will then show you the faster and more efficient way to do this using an Advanced Filter. This feature allows you to filter your data based on specific criteria, making it perfect for Tad's situation. To use the Advanced Filter, you will need to set up a Criteria Range, which is simply a list of the invoice numbers you want to filter for. Make sure to include the heading from the original data set in the first cell. Then, go to the Data tab and select Advanced Filter. Choose to filter the list in place and specify the Criteria Range. Click OK, and just like that, you will have all 27 of your desired invoices filtered in no time. If you want to learn more about Filters and Advanced Filters, be sure to check out my book, Power Excel with MrExcel, 2017 Edition. You can find the link in the top right-hand corner of this video. And a big thank you to Tad for his question and for attending my seminar. I hope this solution helps you and anyone else facing a similar filtering challenge. Thanks for watching, and I'll see you in the next episode of the MrExcel netcast! 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/ #excel #microsoft #microsoftexcel #exceltutorial #exceltricks #evergreen #excelfilter #exceldatafiltering This video answers these common search terms: how to filter in excel based on a list how to filter data in excel based on a list how to filter by list in excel how to filter by values in a list excel how to filter a report by a list in excel how to filter in excel by a list how to filter an excel with a list how to filter down on items in excel using a list how to extract a dynamic list from a data range based on a criteria without filters in excel filtering in excel too time-consuming with many items optimizing excel filter for multiple items improving filter selecting speed in excel efficient way to filter many items in excel excel filter alternatives for selecting multiple items quick filtering in excel for many selections bulk filtering in excel without slow dropdowns excel advanced filtering techniques streamlining data selection in excel how to filter in excel with advance how to advanced filter in excel filter a column in excel using a list how to filter a column in excel with a list how to use advance filter on excel what is an advance filter excel how to use the "advanced filter" in excel Table of Contents: (00:00) Filtering to 27 invoices (00:17) Tedious process of filtering one by one (00:32) Introduction to Advanced Filter method (01:00) Setting up Criteria Range (01:48) Results using Advanced Filter (02:00) Advanced Filters covered in Power Excel with MrExcel book (02:10) Summary of Advanced Filter method for filtering to specific invoices (02:42) Thanking Tad and audience for tuning in With a large data set, scrolling to find the 27 invoices will not be fun. Searching for each invoice and remembering to click Add to Selection will not be fun. Instead - use the Advanced Filter Set up a criteria range… First cell contains the Invoice heading. List the invoices vertically below. Choose one cell in the data set. Data, Advanced Filter Filter in Place Use a Criteria Range Select the criteria range including the heading Click OK Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1154000/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920