Array/Matrix outputs in numbers.

Question

Level 1

8 points

Array/Matrix outputs in numbers.

So some functions gives as array output (eg. reglinp). In other programs you just simply select rows and columns for output and putting formula for them and the array is outputted into them. In Numbers only way I found is to copy the function into all those cells i want the array to be outputted to put it into INDEX() function.

eg. index(reglinp(A1:3;B1:B3;1;1);1;1) will output first row and first column of reglinp array function output.

Is there the way to do it in the way it is done in all other office programs so you don't need to loose time for all those unnecessary operations?

MacBook Pro 13", macOS 10.14

Posted on Mar 21, 2019 4:24 AM

Reply

Answer 1

SGIII

Level 8

37,562 points

Mar 21, 2019 7:49 AM in response to ScriptNewbie

No, sorry, Numbers no longer has a formula bar at the top. As you've discovered it doesn't try to be just like other spreadsheet programs. It does some things quite differently.

Remember you can give feedback to Apple via Numbers > Provide Numbers Feedback in your menu.

SG

Reply

Answer 2

SGIII

Level 8

37,562 points

Mar 21, 2019 6:23 AM in response to ScriptNewbie

I see. You are talking about the LINEST function, which I understand in Numbers you wrap within the INDEX function as described here and you don't want to do that.

You can give feedback to Apple via Numbers > Provide Numbers Feedback in your menu.

SG

Reply

Answer 3

ScriptNewbie Author

Level 1

8 points

Mar 21, 2019 6:03 AM in response to SGIII

To output the whole array from function by typing it only once and without INDEX() function. I described it in first post.

eg. REGLINP() outputs array. I want to see and have the whole array not only the (1,1) index of it.

Here is the example from google docs - it gives me the whole array. In numbers I only get one cell in wich there is only the value from first row first column of the array the function outputs.

Reply

Answer 4

SGIII

Level 8

37,562 points

Mar 21, 2019 5:25 AM in response to ScriptNewbie

Is there the way to do it in the way it is done in all other office programs

Not sure what the "it" is here, or which "all other office programs" you refer to. What are you trying to do?

SG

Reply

Answer 5

ScriptNewbie Author

Level 1

8 points

Mar 21, 2019 6:37 AM in response to SGIII

Sorry I wrote non english name of this function - I was sure it was one :)

Yep, I am looking for simple way to see this whole array. It is very convenient in excel, libreoffice etc. where I just select cells I want this function to give me this whole array to, and write the formula in {} (in the formula bar on the top of the program).

Also is there the way to have the formula bar on top or the bottom in numbers where I can edit the formula of selected cell like it is in most calc programs?

Reply

Array/Matrix outputs in numbers.

Similar questions