Video Lesson

Dynamic Array Functions

Pro

Learn FILTER, SORT, SORTBY, and UNIQUE through three focused worksheets, including multi-condition filters, multi-level and external-range sorting, unique rows and columns, spill references, and the #SPILL! error.

This is a Pro lesson

Get Pro to unlock this lesson, the full course, and all site features.

See Pro Details

Want to sample the course first? Try the free Conditional Aggregation video lesson and quiz.

Try Free Lesson Try Free Quiz

Video Lesson Workbook

The reference workbook for this lesson is included with Pro.

See Pro Details