Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Microsoft Adds Dynamic Arrays and New Functions in Excel 365

13 Jun 2019   #1

64-bit Windows 10 Pro
Microsoft Adds Dynamic Arrays and New Functions in Excel 365

Hi I’m Joe McDaid, a Program Manager working on new calculation experiences in Microsoft Excel. I wanted to share some details on an exciting enhancement to Excel’s calculation engine that will supercharge your formulas.

Formulas just got better

Until now, you wrote a formula for each value you wanted returned to the grid. One formula, one value. If you wanted another value, you wrote (or copied) another formula. With dynamic arrays, that all changes.

Now, you can write a formula hit the enter key and get an array of values returned (or “spilled”) to the grid. One formula, many values. This will allow you to build more capable spreadsheets, faster, with fewer formulas and less chance of error.

Using Dynamic Arrays

Dynamic arrays support is built into the calculation engine, so all you need to do is write a formula that returns multiple values. This may sound complex but it’s surprisingly easy. Here’s an example:
  • Type some names into cells A1, A2 and A3
  • In B1 type =SORT(A1:A3) and hit enter
  • BOOM! you have a sorted list of names
In addition to the new SORT function, dynamic arrays are accompanied by the all new UNIQUE, FILTER, SORTBY, SEQUENCE and RANDARRAY functions.


Dynamic arrays are currently available to all Insider users on Excel for Windows and Insider Fast users on Excel for Mac. While its currently only available for testing on Windows and Mac, dynamic arrays support is coming to all platforms.


As we prepare to make dynamic arrays generally available to all Excel 365 users, we’ve been actively listening to community feedback. Based on the feedback we’ve received to date, we’ve already taken up some improvements as detailed here. So please keep the great feedback coming!

The best way to provide feedback on Dynamic Arrays and the six new functions is to use the Send-a-Smile ) and Send-a-Frown ) buttons in Excel.

Source: Dynamic Arrays and New Functions in Excel! - Office Insider Blog

My System SpecsSystem Spec

 Microsoft Adds Dynamic Arrays and New Functions in Excel 365

Thread Tools

Similar help and support threads
Thread Forum
Microsoft Adds OneDrive to Bug Bounty Program
Source: Microsoft Bounty Programs Announce Expansion Bounty for Microsoft OneDrive | MSRC
Changing functions in a Microsoft mouse
Hello, Microsoft Wireless Optical Desktop 2000 (Keyboard + Mouse). The wheel is a bit hard to press. Tilting is softer and easier. Is it possible to change the tilt function (horizontal scroll) to middle-click? I'd appreciate your help.
Hardware & Devices
Microsoft adds a Lab of Things to its HomeOS
Read more at: Microsoft adds a Lab of Things to its HomeOS | ZDNet
Cannot access the Ribbon functions in Excel 2007 or Word 2007
I have Office 2007 on Windows 7. When I am working on a sheet (or document) the ribbon can become inaccessible, nothing works when I click it (like a 'Not Responding' screen). If, I switch to another open sheet/doc and then switch back the ribbon is accessible again! I have...
Microsoft Office
Microsoft adds H.264 for Chrome

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 14:20.
Twitter Facebook