When entering the functions, if you use the selection method to insert references, you will see Excel’s Table structure referencing at work instead of the actual range (array) references that I use.

XLOOKUP () is one of several newish dynamic array functions. If you’ve ever entered an expression using Ctrl + Shift + Enter, then you’re already familiar with how Excel used to work with ...

Excel running totals made easy with dynamic arrays. Explore advanced functions for accurate, flexible data handling and improved performance.

This guide by Excel Off The Grid will walk you through a step-by-step method to dynamically insert blank rows between items, whether you’re sorting, filtering, or grouping data.