Excel for Engineers and other STEM Professionals - Part 7: News! Dynamic Arrays in Excel

This is not the article I planned for this issue but it would beimpossible to continue the series discussing array formulaswithout addressing the massive changes announced by John Campbell and Joe McDaid at Microsoft Ignite held in Florida at the end of September [1]. In future any formula that references an array where a value is expected will return a dynamic array as its result; ‘Ctrl+Shift+Enter’ (CSE) will no longer be required for ‘normal’ array formulae.

Document Details

ReferenceBM_Jan_19_3
AuthorBartholomew. P
LanguageEnglish
TypeMagazine Article
Date 1st January 2019
OrganisationMDAO Technologies
RegionTechnical

Download

Purchase Download

Order RefBM_Jan_19_3 Download
Non-member Price £5.00 | $6.21 | €5.54

Back to Search Results