Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Extract Data based on a Drop-Down List selection in Excel. That video is uploaded by TrumpExcel at 2014-02-02T07:04:44-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [jMFsA1dcXb8]
| Name | Extract Data based on a Drop-Down List selection in Excel |
| Video Uploader | Video From TrumpExcel |
| Upload Date | This Video Uploaded At 02-02-2014 15:04:44 |
| Video Discription | 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 jMFsA1dcXb8 |
| Category | Education |
| Tags | Extract Data based on a drop down list selection in Excel | dropdown list in excel | excel drop down list | Fetch Data from drop down list | how to create drop down list in excel | excel data validation | excel drop down | data validation | Drop-down List | Excel | Microsoft Excel (Software) | Extract Data | drop down list selection in Excel | drop-down list | filter data using drop down list | make drop-down list in excel | in cell drop down | drop down list in cell | microsoft excel |
