Excel Dynamic Arrays: Data Validation List Dropdown: Unique, Sorted & No Blanks EMT 1523

In this video learn how to create a Data Validation Dropdown List that contains only a Sorted, Unique List with No Blanks based on a column in a Table . See the New Office 365 Dynamic Arrays and the UNIQUE, SORT and FILTER Array Functions, as well as the Spilled Array Notation (Syntax) for the Data Validation Drop Down List Dialog Box.
Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516)