FAQ

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.
Dynamic array formulas in non-dynamic aware Excel
Working with dynamic arrays in non-dynamic aware Microsoft Excel versions
​

Frequently Asked Questions - Previous

Common Issues

Last modified 1yr ago