Forum Discussion

Felima65's avatar
Felima65
Copper Contributor
Jun 23, 2023

Excel cannot type a horizontal array constant

Hi, this is a very basic question about array constants.

 

I´m using a brazilian portuguese Corporate Office 365 Excel and I´m studying about static and dynamic arrays. It works just fine when I enter a vertical array contant (just like described in the MS article below) by typing the values in a cell within curly braces separated by semicolons.  However, when I do the same trying to create a horizontal array (separated by commas) excel complains there is an error in the formula, no matter if I press Enter or CSE. What am I doing wrong?

 

Thank you in advance.

 

https://support.microsoft.com/en-gb/office/use-array-constants-in-array-formulas-477443ea-5e71-4242-877d-fcae47454eb8

 

Excel Formulas and Functions

 

 

5 Replies

Resources