 | |
| Excel: Extract unique items for dynamic data validation drop down list |
Your original data set contains multiple instances of the same entry but you'd like to have a drop-down list that only includes unique items in Excel? And you'd like to do this with an Excel formula? This video is for you. 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)
Related Topics:
- Excel Dependent Drop Down List with Tabular Data without Named Ranges
- Realistic Case: Dependent Drop-Down Lists in Excel with Multiple Words and Spaces in 1st List
- Excel Simple Dependent Drop down List based on numbers (Index without match)
- Excel: Dependent Drop Down Lists with OFFSET, CHOOSE, INDEX and INDIRECT
Post a Comment