Excel Magic Trick 1023: Extract Unique List of Names For Dynamic Data Validation Dropdown List

Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1023.xlsx Download workbook example from video: http://people.highline.edu/mgirvin/excelisfun.htm Excel Array Formula solution to create a Dynamic Data Validation Dropdown List from a list of names with many duplicates. The Dropdown will update anytime new names to the original data set. This solution does not sort the names. Many Array Formula Concepts in this video: 1. Dynamic Defined Name for list of names: INDEX and MATCH function that can handle empty cells. 2. Formula to count unique names in a column that can handle empty cells. 3. Formula to extract unique items (names) that can handle empty cells. 4. Dynamic Defined Name for list of unique names: INDEX function that can handle cells with null text strings. 5. Data Validation Dropdown list with Defined name that will pick up any new names added to the original list.