matrices

  1. R

    Formula for analysing customer cohorts

    I have developed a formula which shows customer activity by cohort (each month a new customer "Cohort" comes on stream). The pattern is linear and in each month each customer who is active buys one item. As an example CUstomers in their first year will buy three times Month 1,5, and 9. In Month...
  2. F

    Populate results that requires matrices function

    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...
  3. A

    Creating a Function to Compute the Dot Product in VBA

    I have been trying for hours to create a function that will find the dot product of two independent columns. I have very limited knowledge in VBA and my professor is no help. This is what I have right now, which is heavily based on what I learned in class. Does anybody have suggestions of what...
  4. L

    How to Create a Customized Function in Excel VBA for Multiple Matrices Multiplication?

    I want to create a function in Excel VBA that can do matrices multiplication for multiple matrices (undefined numbers of augments). The following is my code (I use ParamArray in this function), but it returns an error. Could anyone help me debug it? Function MultMMult(ParamArray X() As Variant)...
  5. S

    Trying to do a triple lookup

    Hi all, I'm trying to do, essentially, a triple lookup. I've got 14 Matrices, and I want to select one of the matrices, a vertical value from the selected matrix, and a horizontal value from the selected matrix, and get the intersecting value. I've already got down the VLOOKUP/MATCH pair for...
  6. C

    How to merge / mix 2 matrices, with Conditional Formatting or No?

    I'm dealing with this problem in the last couple of days. I have formatted with Conditional formatting two color matrices 52x24 cells in two different sheets and both sheets (matrix results) are linked to the first numerical data base sheet. What I want is to generate the third matrix which...
  7. C

    Conditional formating Matrices - mix / merge

    I'm dealing with this problem in the last couple of days. I have formatted with Conditional formatting two color matrices 52x24 cells in two different sheets and both sheets (matrix results) are linked to the first numerical data base sheet. What I want is to generate the third matrix which is a...
  8. A

    Two Disparate yet Overlapping Matrices (Proportional Equivalencies)?

    Hi All Struggling with an issue that I am sure someone must have faced before, but I can't find an answer when I searched the forum, so hoping someone can help me. Essentially I am trying to convert an OD matrix into another OD matrix, by which I mean I have OD matrices from two disparate...
  9. B

    Storing values from row operations

    I built a function that takes a matrix, performs simple linear algebra, and outputs a new matrix with 0's in the bottom left corner. This is great but I need the code to remember the value it multiplied by ("the factor") to get each 0 in the bottom left corner and output each factor later maybe...
  10. M

    Making an 18x18 Matrix

    Hello! I have to make an 18x18 matrix calculator using excel for my math project. It should be able to solve the determinant, the inverse, the answers if there were a given system of equations, and the L&U of the matrix. I know I could easily do those by using the built-in matrix functions, but...
  11. E

    Is My Economic Model too Difficult for Excel to Handle?

    I'm trying to run a mathematical simulation of an economic model. I'm wondering what is the best structure to solve this problem, or whether I should consider purchasing Matlab instead. (I'm very poor and buying a Matlab program may be out of my budget since I'm not a student or associated with...

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