matrix

  1. J

    Output data from table

    Hello, I have a table with A, B, C and D down one side and A, B, C and D across the top, in the middle of that table are values. I want to get excel to then be able to find the value of any cell, for example A,C or D,B and so on, and provide the value. Any help would be greatly appreciated...
  2. M

    Adding measures to a matrix

    Hi Everyone, I am currently making a daily store sales table and am having trouble adding 2 measures that I created (previous week's sales and % change). The issue I am having is when I drop the 2 measures into my matrix, the format changes to something completely unusable. See below. Also, I...
  3. 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...
  4. E

    Max Difference Between Two Dynamic Ranges

    Let's assume our example data set is as follows: Column A1:A9 10 12 14 12 10 15 20 25 20 Column B1:B9 10 10 11 11 9 9 11 11 10 I'm looking for a one cell formula/vba code that will show the maximum difference between the maximum value of a dynamically increasing range in column A1:A9 and...
  5. D

    return row and column headers for matrix for duplicate values

    Hi all I am busting my head for past few days in getting the formulas to work. I have a building condition survey spreadsheet where the physical condition of different items in different rooms get evaluated. Each item in each room receive a value from 0 to 3. 0=good and 3 = severe / critical...
  6. B

    Calculate Difference Between Dates in Matrix Using Measure

    I have a Matrix visual with the following: Dates (MM DD YYYY) on Columns ApplicationKey on Rows Application Status on Values The Dates (datetime value) column represents the date/datetime the application progressed from one status to another; this could be the same date but minutes or...
  7. K

    Matrix Visualization with data from same source filtered by 2 separate date filters

    I have a data source with sales data by store. Columns in this data include actual sales, forecasted sales, week date, weekending (saturday), region for the store, and which warehouse the store received the sold items from. I need to create a matrix visualization in which the user can filter the...
  8. S

    Using a Cross-Reference Matrix to input text into another cell

    I was given a cross-reference matrix, a section of it is copied below. The numbers in Row 2 and Column C are unique identifiers. Test IDT_001T_002T_003T_010C_001Activity TitleCold Gas Blow DownBottle Piercer CharacterizationCG Assy CharacterizationGG HydrostaticSys...
  9. V

    Total share in a company

    Hi, I am trying to calculate a total share in a companies for several interconnected companies. The simplified model is as follows Company/Company A B C A - 10% 10% B 10% - 10% C 15% 20% - So the company A holds directly 10% in company B which holds 20% in company A. That makes...
  10. A

    Create a Matrix from a List

    Hi everyone, It is my first post and first of all, thanks for all the support you have provided me in the past. I need your help in a complicated (at least for me) issue. I would like to populate the content of a matrix based on a list. I have got a list of 10 products to be develop...
  11. M

    COUNTIF INDEX type issue. Producing a summary table..

    Hi folks, After success on this board earlier this week, I’ve decided to put together a management information type system for my department at school. I currently teach at different sites and I’m trying to ensure an even split of equipment between sites. I’ve put a simple site, course and...
  12. M

    Help with index match sumif and more.

    Hi there, I’m a teacher who is looking to prepare better for the academic year. I teach a range of courses which require different amounts of time to setup and I’m keen to get a better understanding of the set up times for each course I teach. I have attempted todo this is a matrix format, but...
  13. E

    Populate table with respect to another table

    Hi Excel 2016 (Windows) 32 bit ABCDEF 1Table 1 2Place/Week12345 3A12ZZZZ 4B143 5 6Table 2 7Place/Week12Z45 8A12ZZZZ 9A12ZZZZ 10B143 11B143 Sheet: Sheet1 As shown above, I need to create Table 2 with data from Table 1. The first column of Table 2 takes reference from the first...
  14. 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...
  15. H

    How do I create Simularity/Correlation Matrix using Non-Numeric Data

    Hello, I am trying to create a matrix of constituents in our database comparing their Relationships to other constituents. I have a list of constituents, and each one has a list of people they have relationships with (represented here are constituent IDs for people attached to their record as a...
  16. A

    Formula required for work - Lookup Matrix to provide result in cell

    Hi All, I have this assignment at work, and i tried bunch of formulas but cannot get this (hopefully) easy formula right, i have tried INDEX, MATCH, COLUMN, COUNTIFS, SUMPRODUCT but all to no avail; i cannot comprehend the complexity and turn it into simple logic. In the image attached, i have...
  17. W

    Skills Matrix Comparison in Excel

    Good afternoon all, I've created a Skills Matrix in Excel where engineers listed in columns can select their skill set against each application. They can either choose NONE, BASIC, INTERMEDIATE and ADVANCED (An Example is shown in the Skills Matrix Diagram.jpg attachment. Now, what I want to...
  18. I

    Using Excel solver (or other method) with a common objective in multiple cells by changing the same variables, subject to constraints

    Hi, I am struggling with quite a complex problem in which I think I may be able to solve or at least partially solve using the Excel solver tool. I am trying to set up a design of experiments analysis in which I have a number of parameters at two levels. I have one specific objective which I...
  19. L

    Converting data from matrix to list format

    Hi Everyone, Firstly, this forum is really great. I generally do my utmost not to post a new thread and read through other materials and try to work it out when I can. Here are some pre-existing materials on this topic that I already read through...
  20. B

    Excel formula to auto-select a figure on certain conditions

    The pay of an employee in applicable level in the Pay Matrix will be fixed by multiplying the existing basic pay by a factor of 2.57, rounded off to the nearest rupee and the figure so arrived at will be located in that level in the Pay Matrix and if such an identical figure corresponds to any...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top