Forum Discussion
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
5 Replies
I guess for your locale it shall be a slash instead of comma
You may check in attached file as well.
- Worked like a charm. Thank you.
Felima65 , you are welcome
You were using the en-gb version. Switch to pt-br.
- You're right. Thank you.
