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

Watch on YouTube

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