Preview of Dynamic Arrays in Excel | Microsoft Community Hub

With dynamic arrays, you can write a single formula and get an array of values returned. One formula, many values. This will allow you to build more capable...