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 while D1 shows 1. The formula will still show =A1:A3. If I move the target cell to D2, the formula in D2 shows =A1:A3, but cell D2 now shows 2 while cells D1, D3 and D4 are blank. If I move the target cell to D6, the formula shows =A1:A3 while D6 shows #Value. Is there something that I need to enable to have cells D1 through D3 show the values from A1 to A3?

​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 while D1 shows 1. The formula will still show =A1:A3. If I move the target cell to D2, the formula in D2 shows =A1:A3, but cell D2 now shows 2 while cells D1, D3 and D4 are blank. If I move the target cell to D6, the formula shows =A1:A3 while D6 shows #Value. Is there something that I need to enable to have cells D1 through D3 show the values from A1 to A3?  Read More

​