Instead of using={1,2;3,4}, is it possible to reference each of these numbers as cell references. So something like ={RC1,RC2;RC3,RC4}. ie a single formula in a cell that describes a 2x2 array.
I am trying to solve quadratic equations in a single formula. Ultimately, I want to be able to input a formula something like =index(minverse({RC1,RC2;RC3,RC4}*mmult({RC5;RC6}),1)
many thanks