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.
------------------------