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

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