Dynamic Arrays Article

Jeff Lenning|May 5, 2020||Dynamic Arrays, FILTER, Sort, Spill, SUMIFS, UNIQUE, XLOOKUP

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

Posted in Excel, Functions

Jeff Lenning

I love sharing the things I've learned about Excel, and I built Excel University to help me do that. My motto is: Learn Excel. Work Faster.

Stay Connected

If you'd like to be notified when I write a new Excel article, enter your name and email and click SUBSCRIBE. You can unsubscribe anytime, and I will never sell your email address.