Dynamic arrays are native

All formulas will now run on a new calculation engine.

This includes older functions and formulas not originally designed to work with dynamic arrays.

For example, theLEN functionreturns the number of characters in a string.

Traditionally, you’d use it with one cell at a time.

This a big change that can affect all kinds of formulas.

For instance, theVLOOKUP functionis designed to fetch a single value from a table, using a column index.

With a column index of 2, I can use name to lookup the building.

We can lookup building and extension in a single formula.

Let’s look at one more example.

With dynamic arrays, I can use full ranges and enter the formula in one step.

Notice Excel returns all results in the spill range.

This formula is easy to modify as well.

When I press enter, all results are updated.

As always, these results are dynamic.

If I change a name, we get a new result immediately.