Hi all!
Thanks for the help.
Stuck with another problem here.
Given I have some data points as shown, X, Y and Z.
I am supposed to compute the result of matrices with all data points available. In this case, I should be able to generate 5 different sets of results since there are 5 sets of X, Y and Z points.
However, I am facing difficutitiles computing all 5 sets results simultanetously and placing them in a table. This is because autofill doesn't really work well for matrices function. I was previously able to do stuff like this using VBA's autofill function, but realized that for matirces, there will be problem ajtofilling due to SPILL errors etc.
Does anyone have any idea/workaround so that I can present my results neatly in a column for al 5 sets of results? Thanks!
PS: Screenshot answer has error #VALUE because it's still in X, Y and Z.
Thanks for the help.
Stuck with another problem here.
Given I have some data points as shown, X, Y and Z.
I am supposed to compute the result of matrices with all data points available. In this case, I should be able to generate 5 different sets of results since there are 5 sets of X, Y and Z points.
However, I am facing difficutitiles computing all 5 sets results simultanetously and placing them in a table. This is because autofill doesn't really work well for matrices function. I was previously able to do stuff like this using VBA's autofill function, but realized that for matirces, there will be problem ajtofilling due to SPILL errors etc.
Does anyone have any idea/workaround so that I can present my results neatly in a column for al 5 sets of results? Thanks!
PS: Screenshot answer has error #VALUE because it's still in X, Y and Z.
