How-To Geek via MSN

How to use dynamic array functions in Microsoft Excel

Functions like FILTER, SORTBY, UNIQUE, XLOOKUP, and VSTACK transform static grids into real-time data systems.
TechRepublic

How to generate random text using the RANDARRAY() function in Excel

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel. The recent article How to ...
Neowin

Microsoft adds Dynamic Arrays to Excel to make formulas more capable

Microsoft is making some improvements to how formulas work in Excel, with a new feature called Dynamic Arrays that allows ...