Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

Microsoft just release a brand new feature for Excel called Dynamic Arrays. This is a set of functions, and new functionality, that allows us to create formulas that return multiple results to multiple cells.
Read the article, download the file and FREE eBook: https://www.excelcampus.com/functions/dynamic-array-formulas-spill-ranges

UPDATE: These new features are now available to all users on the free Office Insiders Fast channel for Office 365. See the link above for more details.

Dynamic arrays will eventually replace the Ctrl+Shift+Enter array formulas we use today. This will make is so much easier to write array formulas, and work with the output (spill range).

The cells that the dynamic arrays output to are known as the Spill Range. This range is dynamic and automatically updates (spills) as changes are made to the source range or its precedents.

The spill range can be referenced with the new Spill Ref notation (A4#). This is the first cell in the spill range, followed by the hashtag or pound symbol.

In the video I share the new UNIQUE function that removes duplicates and returns a list of unique values to the spill range.

I show how we can combine this with the new SORT function to sort any range.

The FILTER function allows us to apply multiple filters to a range and output the results into a spill range with multiple rows and columns.

This new functionality for Excel makes it much easier to write array formulas, and opens up a new world of possibilities.

These new functions and features are currently available to all users on Microsoft’s Office Insiders Fast (Monthly Targeted channel) program. The Insiders program is free for all Office 365 subscribers and gives you access to early release builds and features. See this link for more info.
https://www.excelcampus.com/functions/dynamic-array-formulas-spill-ranges

Related Content:

Ctrl+Shift+Enter Array Formulas: https://youtu.be/I23Cy8FkMLY

How to Create Data Validation Drop-down Lists: https://youtu.be/KGnvCKiOLM0
00:00 Introduction
02:48 Sort Function
03:46 Sort Unique Function
04:20 Data Validation
08:17 Free Download