This video demonstrates the following using the new UNIQUE, SORT and FILTER functions in Excel.
Create a dynamic drop down list using the UNIQUE and SORT functions
Create a FILTERED list using the FILTER function
Sort a FILTERED a list using the SORT function.
------------------------