displaying array results

Question

When using minverse or mmult only the first cell is displayed. How do you display the resulting array?

Answer 1

When Tushar says enter it as an array formula he means press Shift+Ctrl+Enter, not Enter.

This is necessary to display all the results of the matrix operation.  So you need to know what size the results matrix should be so you can select the appropriate size range.  For example a 3x1 array and a 1x3 array will result in a 3x3 array, so if you select 2x2 range and array enter MMULT you will see only 4 of the 9 results.  If you select 4x4 range you will get your nine results plus a bunch of #N/A errors.

---

If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire

Answer 2

Hi Ashish

I think you are mistaken.  See help for MMULT.  It returns an array with the same number of rows as array1 and the same number of columns as array2.  So the only case in which it returns a single value is where you are multiplying a one row array by a one column array.

---

Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk

Answer 3

Hi,

MMULT(), being matrix multiplication will return a value and not an array

--

Regards,

Ashish Mathur

Microsoft Excel MVP

www.ashishmathur.com

"Jim M1342" wrote in message news:d9da3eb5-7c22-40ed-8835-416dc8ead625...

When using minverse or mmult only the first cell is displayed. How do you display the resulting array?

---

Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com

Answer 4

You should select the range of cells that will contain the result values and enter the formula as an array formula.  The help for MMULT provides more details in the note at the end of Example 1.

---

Tushar Mehta (Technology and Operations Consulting)

www.tushar-mehta.com (Excel and PowerPoint add-ins and tutorials)

Microsoft MVP Excel 2000-Present