In this example, the years in cells A2, A8, and A17 interrupt the GROUPBY function's result. I can use the filter array argument to tell Excel to ignore any cells in column A that contain numbers ...

The XMATCH function ... FILTER is particularly valuable for tasks requiring detailed exploration of datasets and the creation of dynamic, condition-based reports. Pivot tables are among Excel ...