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