Dynamic Arrays Article

Microsoft has been hard at work updating Excel’s calculation engine. Depending on the version of Excel you’re using, you either have—or will have when you update—access to some capabilities that are sure to change how you think about and use Excel.

I wrote about one of the new capabilities called Dynamic Arrays for California CPA Magazine. In summary, when a formula returns multiple values, the results spill out of the formula into adjacent cells (the “spill” range).

If you’d like to learn more, check out the article below.

Dynamic Arrays

 

 

 

Get a quick email notice when a new Excel article is available

  • This field is for validation purposes and should be left unchanged.

This article was written by Jeff Lenning

Leave a Reply

Your email address will not be published. Required fields are marked *

For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

I agree to these terms.