Spill arrays that automatically update with FILTER, SORT, UNIQUE.
“Dynamic Arrays: FILTER, SORT, SORTBY, UNIQUE” is part of Excel Zero to Hero — Complete Master Course. Free preview lessons are open to everyone; the remaining lessons are for enrolled learners.
Module 6: Advanced Lookups
Module 7: Dates & Dynamic Arrays
Module 8: PivotTables & Charts
Module 9: Advanced Formulas
Module 10: Analysis & Power Tools
Module 11: Power Pivot & VBA
Module 12: Automation & Capstone
