Hi,
When I write the following code I expect the answer should be number of columns covered in the array {1,2,3;4,5,6} But instead receive I an error code, see attached file.
=COLUMNS({1,2,3;4,5,6})
I have pressed Ctrl+Shift+Enter
Thank you
/Henrik
Hi Henrik,
I can't reproduce that error. The formula returns 3 for me.
Do you get the same error with:
=COLUMNS({1,2,3})
OR
=COLUMNS({0,0,0;0,0,0})
Both should return 3. The second row, specified by the semi-colon, is irrelevant/discarded by COLUMNS anyway.
Mynda
Hi Mynda,
Thank you for your answer and your effeort to help me.
I have already solved the problem. In my region (I live in Sweden) is the "," replaced by ""
When I wrote =COLUMNS({123;456}) did it work fine.
Thank you again!
Br
Henrik
I'd assume it's your regional settings. You probably need something like:
=COLUMNS({123;0})