What are excels 7 new dynamic array formulas

Excel recently introduced 7 new dynamic spilled arrays: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY & SINGLE. In this video I show you what each of these new formulas can do.

These formulas are currently only available on the Office Insider version of Office 365 or on Google Sheets.
--------------------------------------------------------------------------------
#exceltutorial #excelformulas #exceldynamicarrays

Microsoft Office 365, 2016, Office Insider, Version 1903
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:

[ExcelID]

Cool, your explanation is very easy to understand

[karinaadcock]

The SINGLE formula has now been replaced by the @ symbol. So instead of =SINGLE($A$3:$A$14) it is now =@$A$3:$A$14

[miso]

Very easy to follow..thanks for the video

[alexclark]

Your videos are great! Thanks for the content.

[naturesage]

forrmula replace=sheets1aA22? with array

[erictsang]

Karina

Can we use the filter function to filter selected rows/fields?
Eric

[soumyadeep]

I am not able to these formulas in my excel