A couple of articles ago I introduced the new Dynamic Array Microsoft Ignite held in Florida at the end of September 2018 [1]. At functionality announced by John Campbell and Joe McDaid at the time, though, the new functionality was only available for beta-testing as part of the ‘insider’ program of Office 365. I stuck it out for several months in the hope that dynamic arrays would appear in my Semi-Annual version but eventually I caved in and licensed an additional personal copy that I could switch to ‘insider’ for its weekly updates. Now I just cannot envisage going back to a standard version! So far with this series I have been focusing on array formula but I'd be interested in hearing from you if there are other topics you would like to explore. Some of the topics we could cover include VBA, powerquery, pivot tables, application of array methods to solve UQ problems and if you would like to get in touch please email excel@nafems.org. The worksheet which accompanies this article can be downloaded from nafe.ms/pivot
Reference | BM_Oct_19_11 |
---|---|
Author | Bartholomew. P |
Language | English |
Audiences | Developer Student Analyst |
Type | Magazine Article |
Date | 1st October 2019 |
Organisation | MDAO Technologies |
Region | Global |
Order Ref | BM_Oct_19_11 Download |
---|---|
Non-member Price | £5.00 | $6.33 | €6.05 |
Stay up to date with our technology updates, events, special offers, news, publications and training
If you want to find out more about NAFEMS and how membership can benefit your organisation, please click below.
Joining NAFEMS© NAFEMS Ltd 2025
Developed By Duo Web Design