Skip to content

Dynamic Arrays now in Excel for iPhone and iPad

Microsoft has added Dynamic Array functions to Excel for iOS (iPhone and iPad) and done it in an uncharacteristically low-key way.

Dynamic Arrays are now available across all Office 365 platforms; Excel 365 for Windows and Mac, Excel for Android, Excel Online (web) and now Excel for Apple devices.  That’s an important milestone that Microsoft has let pass without a mention, let alone some justifiable hype.

Dynamic Arrays are an important addition to Excel which open up a vast array of opportunities (no pun intended).

Even the term ‘Dynamic Arrays’ is missing from the brief mention in the app update.

  • We’ve added six new functions to supercharge your spreadsheets: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE and RANDARRAY.
  • Quickly type a formula that returns multiple values, and they’ll automatically spill into the neighboring cells.

This applies to Excel for iOS v 2.32 or later.

Do you have Dynamic Arrays in Excel 365?

Excel now has Dynamic Arrays – Windows, Mac and more …

Where’s my Excel with Dynamic Arrays?

 

 

About this author

Office-Watch.com

Office Watch is the independent source of Microsoft Office news, tips and help since 1996. Don't miss our famous free newsletter.