The "Dynamic Arrays" added to Excel 365 have fundamentally changed how formulas are written. Until now, the standard in Excel formulas was "one cell returns one result." With dynamic arrays, "a ...