Dynamic array functions represent one of the most exciting new features in Excel. Although generally as straightforward in syntax to use as other Excel functions, their underlying mechanism for handling data differs significantly. Unlike traditional functions that deliver a single data piece in a single cell, dynamic array functions can return multiple pieces of data, … Continue reading How to understand the # spill operator in Excel