In this video tutorial, learn how to extract or filter data in Excel based on a drop-down list selection.
This Excel trick is extremely useful in situations where you have a huge dataset and you want to extract part of it by making a selection.
For example, suppose you have the sales transaction records or various products. You can use this technique to select the product item from the excel drop down list and all the records for that item would get extracted and listed separately.
Since this is dynamic, you can change the selection from the drop down, and the results would update instantly.
There are three steps in extracting data based on a drop-down selection:
1. Create a Unique list of items.
2. Create a drop down to display these unique items.
3. Use helper columns to extract the records for the selected item.
It also uses Excel formulas (INDEX, MATCH, ROWS, and SMALL functions) to extract the data based on the drop down selection. It can work for extracting the data on the same or different worksheet in Excel
This is a great way to give the user the flexibility to quickly filter the data and get the records that they need.
For example, you can create this to quickly extract the data based on the selection of country name from the drop down. As soon you the selection is made, this will filter all the records for that specific country.
And you can select another country from the drop-down and it will instantly update and show you the results from the second country.
You can also extend the concept shown in this video to create multiple filters. For example, you can select country and product name and it will extract the data of records that match both the criteria.
Step-by-step written tutorial and download file: https://trumpexcel.com/extract-data-from-drop-down-list/
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos - https://www.youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.
You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/
#Excel #ExcelTips #ExcelTutorial
