Extract Data based on a Drop-Down List selection in Excel
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.
0:00 Intro to the dataset
2:15 Creating a Drop-down List
3:30 Adding Helper Columns to have the formula that will help extract the data
8:18 Extract Data based on the drop-down 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/
Here are some other similar videos you may find useful:
✅ Dynamic Filter in Excel - Filter As You Type (with & without VBA) - https://www.youtube.com/watch?v=xBRkCv6RWcE
✅ Advanced Filter in Excel - https://www.youtube.com/watch?v=ZUFEqjDLM2I
Also, I have made all of my courses available for FREE. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
#Excel #ExcelTips #ExcelTutorial
Видео Extract Data based on a Drop-Down List selection in Excel канала TrumpExcel
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.
0:00 Intro to the dataset
2:15 Creating a Drop-down List
3:30 Adding Helper Columns to have the formula that will help extract the data
8:18 Extract Data based on the drop-down 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/
Here are some other similar videos you may find useful:
✅ Dynamic Filter in Excel - Filter As You Type (with & without VBA) - https://www.youtube.com/watch?v=xBRkCv6RWcE
✅ Advanced Filter in Excel - https://www.youtube.com/watch?v=ZUFEqjDLM2I
Also, I have made all of my courses available for FREE. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
#Excel #ExcelTips #ExcelTutorial
Видео Extract Data based on a Drop-Down List selection in Excel канала TrumpExcel
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Create Dynamic Excel Filter - Extract data as you type39 - Extract Data from a Table based on User Selection in Excel using Power QueryExcel LAMBDA FunctionHow to Auto-Populate Fields in Excel Using a Drop-Down and VLookup in Excel5 Excel Functions YOU NEED in 2021Drop Down Lists in Excel - Masterclass (incl. Dynamic, Dependent & Searchable Drop Down Lists)INDEX MATCH Explained (An Alternative to VLOOKUP)Excel Magic Trick 913: Select From Drop Down and Pull Data From Different Sheet🤓Extract All Data Of Same Repeated Lookup Value 👍 Using Vlookup In Excel || HindiHow to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEXHow To Create Multiple Dependent Drop Down Lists In ExcelSearchable Drop Down List in Excel (Very Easy with FILTER Function)How to use Excel Index Match (the right way)Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)How To | Create Dependent Drop-down Lists in ExcelWhen Should you Use the Hash Sign (#) in Excel Formulas?How To Auto Populate Text From A Drop-Down List Selection in MS Excel - Create Fillable FormsSmart Dependent Drop-Down Lists in Excel: Expandable & Exclude Blank Cells10 Super Neat Ways to Clean Data in ExcelDynamic Filter in Excel - Filter As You Type (with & without VBA)