Many of my favorite new Excel features like FILTER(), UNIQUE() and SEQUENCE() are so-called “dynamic array” functions. But other than being really great, what does it mean to be a dynamic array function? How do they compare to “static” arrays? Let’s find out in this blog post.   What is an array in Excel? First … Continue reading How to understand dynamic arrays in Excel