As an enhancement to Excel’s calculation engine, the Dynamic Arrays functionality enables a single formula to produce results that expand into other cells, as demonstrated in the SORT example below.

Stay tuned There are several new dynamic array functions and over the next few months, we’ll cover several of them. Next up, we’ll be using SEQUENCE () to return the top n values in a data set.

The Array is A2:H151, just as it was in the first example. The Include argument is (G2:G151=J2)* (D2:D151=J5). Note that the FILTER function requires parentheses around each condition if there is more ...