minverse

  1. T

    Matrix Worksheet Function MInverse in VBA with Array

    I have a VBA script error out with "Type mismatch" on the Application.WorksheetFunction MInverse line. How else am I suppose to calculate a matrix inverse? What is the type mismatch? Both arrays are the same size and the matrix defined is invertible. Option Explicit Option Base 1 Function...
    • trough
    • Thread
    • array matrix minverse range worksheetfunction
    • Replies: 3
    • Forum: Excel Questions
  2. T

    MINVERSE()-- How to change array size?

    Hi I am working on a spreadsheet where I want to use built-in MINVERSE() function. However, my array (matrix) size can vary from 2*2 to 50*50. I am going to be using a square matrix; however the size will vary depending on the problem. Is it even possible to use a formula that will 'dynamically'...
  3. A

    Need help with MINVERSE and INDIRECT

    I am trying to use MINVERSE (and then MMULT) to solve a system of equations, but I am having difficulty because the array I need to use in the MINVERSE function are cells that are not next to each other, for example: Instead of having: A1 = 5; B1 = 8 A2 = 3; B2 = 7 and MINVERSE(A1:B2) I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top