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 ...

Upgrade your Excel skills with smarter tools like XLOOKUP and dynamic arrays. Save time, reduce errors, and simplify complex ...