I am automating a template that can contain between 2 and 11 statistical data points and produces an X-Matrix (n x 4)....where 11>=n>=2.
I then use =MMULT() to perform XT*X matrix multiplication which spits out a square matrix (3 x 3).
I always have 11 data points, and use a form-control check box to toggle data points in and out of the analysis. Currently I use an IF statement to make the detoggled lines blank ("").
1) Is there a way to get the MMULT() function to ignore the removed data points? In other words, I want MMULT() to look at an 11x4 array with 2 removed data points and understand that it is a 9x4 array (see pic).
If this is not possible, I follow with two more questions:
2) Is there an automated way to produce a nx4 array from a 11x4 array with blank lines (e.g. 11x4 to 9x4) WITHOUT using macros or VBA?
3) Is there an automated way to change array ranges within a MMULT() function by referencing some logic?
Thanks in advance!
Chris
Bookmarks