Forum Discussion
Array Formulas
Hello! I have a problem with array formulas. Let's say I have an array in cells A1:A3 (A1 = 1, A2 = 2, A3 = 3, for instance). If I type in cell D1 the formula = A1:A3, D2 and D3 will be left empty wh...
Thanks, this worked. Is there a way to have this work automatically? My version is 2019.
In Excel 2019, formulas are not array formulas by default. You have to select the entire range to apply the formula to, and you have to press Ctrl+Shift+Enter.
- Thanks for your help. I will see if I can get a license for a later version or for 365.