You have questions, we have answers!

I don't have dynamic arrays, now what?

If you have an older version of Excel that does not have dynamic arrays, you will have to use Ctrl+Shift+Enter (CSE) when working with array formulas / results as you already do in Excel.

Excel Lab works best with dynamic arrays, we recommend upgrading Microsoft Excel to utilize this enhancement.

To learn more about dynamic arrays, read on Microsoft's support site.

Last updated