Microsoft Excel: Dynamic Arrays (FILTER, SORT & UNIQUE)

Wishlist Share

About Course

Dynamic array formulas return a whole list of results from one formula. This course explains spilling, then shows how to use FILTER, SORT, SORTBY and UNIQUE to build live lists and reports that update themselves when your data changes.

This course is general training. Menu names and features can differ between Excel for Microsoft 365, Excel 2021/2024, older versions, Mac and Excel for the web, so check Microsoft Support for your version. Tutwoo is independent and not affiliated with Microsoft.

What Will You Learn?

  • Understand spill ranges and fix #SPILL! errors Extract matching rows with FILTER, including several conditions Sort and de-duplicate lists with SORT, SORTBY and UNIQUE Combine functions and use the # spill reference in other formulas

Course Content

Course Lessons

  • What dynamic arrays are and how spilling works
  • FILTER: pulling out the rows you need
  • SORT, SORTBY and UNIQUE
  • Combining functions and using the # spill reference

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕