Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1518-1523.xlsx
In this video learn how to use The New Array Functions SORT & UNIQUE with the INDIRECT Function to extract a unique set of values for each column in a table.
Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm
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)