Dynamic Arrays now in Excel for iPhone and iPad

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

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.

dynamic arrays now in excel for iphone and ipad microsoft excel 33316 - Dynamic Arrays now in Excel for iPhone and iPad

  • 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?

 

 

subs profile e1563205311409 - Dynamic Arrays now in Excel for iPhone and iPad
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address