Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Extract UNIQUE Items for Dynamic Data Validation Drop Down List. That video is uploaded by Leila Gharani at 2018-01-03T04:58:42-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [7fYlWeMQ6L8]
| Name | Extract UNIQUE Items for Dynamic Data Validation Drop Down List |
| Video Uploader | Video From Leila Gharani |
| Upload Date | This Video Uploaded At 03-01-2018 12:58:42 |
| Video Discription | Join 400,000+ professionals in our courses here ๐ https://link.xelplus.com/yt-d-all-courses This tutorial guides you through extracting unique values from a list of data using Excel formulas, without the need for complex Control + Shift + Enter (CSE) commands. Split into two parts, the video first demonstrates creating a list of unique items, followed by creating a dynamic drop-down list that includes only these unique items. โฌ๏ธ Download the workbook here: https://pages.xelplus.com/unique-list-file ๐ Key Highlights: โช๏ธ Creating a List of Unique Items: Discover how to generate a unique list of divisions from a table, ensuring the list updates dynamically with any new additions. โช๏ธ Dynamic Drop-Down List Creation: Learn how to create a dynamic drop-down list that references your unique list, without including empty fields. โช๏ธ Utilizing INDEX and MATCH Formulas: Understand the efficient use of INDEX and MATCH formulas combined with COUNTIF to dynamically generate unique lists and drop-down menus. โช๏ธ Advanced Excel Techniques: Explore the practical application of advanced Excel techniques for dynamic data management. As a first step I use formulas to extract the list of unique items to separate cells. My method includes a combination of the Index function together with Match and the Countif function. I'll show you a way to also avoid CSE (control shift enter) as well. In the second part of the video, I use the Offset formula to create a dynamic list that expands depending on the number of items that should be included in the list. The solution provided is dynamic so if you add new data or change data, everything updates automatically (we use Excel's Table feature here) Links to related videos: Dependent-Drop Down List (Followup): https://youtu.be/gu4xJWAIal8 Index Match: https://youtu.be/F264FpBDX28 Offset: https://youtu.be/RPTQjbk2qy4 This video from Kevin Lehrbass summarizes all the different techniques you can use to get the job done: https://youtu.be/BFojgCsKNjw โก๏ธ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join ๐โ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ ๐ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ ๐ฅ RESOURCES I recommend: https://www.xelplus.com/resources/ ๐ฉLetโs connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #excel 7fYlWeMQ6L8 |
| Category | Education |
| Tags | excel extract unique items from a list | excel unique values | excel drop down unique values | excel unique drop down list | extract unique values from column | automatically update drop down list excel | excel unique data validation | countif | offset function | index formula | index match | excel tables | array formula | match function | XelplusVis | duplicate data table | Advanced Excel Tutorials | Leila Gharani | Advanced Excel tricks | Excel online course | excel 2013 | excel 2016 |
