# matrix

1. ### Count Values on a Matrix

Hi, I have this matrix: A B C 5 5 6 1 3 5 4 2 6 1 5 6 and I would like to count the number of "1", "2", ecc for each column: A B C 1 2 0 0 1+2 2 1 0 4 1 0 0 6 0 0 3 So a kind of countifs where you can set "A" and "1" as parameters. Any suggestion? :)...
2. ### How to auto-populate matrix

Hi, I have two separate questions. 1. How would I go about having my matrix quadrants auto-populate once the quadrant is identified on the associated table? I have written several formulas, but keep receiving duplicate "Goals" appear. I have added a second matrix to my workbook to...
3. ### Power Bi matrix Date filtered down when measure dropped in

Hi, This is going to be a bit vague, I had a matrix containing Month and date from 'calendar table' and when I dropped the total sales measure into value it was flited down to one row showing the grand total. I tried to replicate the situation but haven't been able to do so. I'd copied the...
4. ### Distribute elements in matrices of a set number of rows and columns

Hello everyone, I am trying to write a macro to distribute elements into matrices of defined (by user) number of rows and columns. Consider a raw data like this: And I want to distribute in Matrices of, for example, 12 rows x 8 columns but each Element group must start at the beginning of a...
5. ### Employee/Candidate <> Role/Company Match

Hi guys, In the last few days I've been doing an internal assessment of the skills needed by certain companies that we working for, but also the skills that my employees have. With that, I started to create a kind of database in which: the first sheet has the necessary technologies to ensure in...
6. ### 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...
7. ### 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...
8. ### 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...
9. ### 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...
10. ### 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...
11. ### 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...
12. ### 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...
13. ### 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...
14. ### 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...
15. ### 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...
16. ### 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...
17. ### 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...
18. ### 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...
19. ### 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...
20. ### 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...

### 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.

### Which adblocker are you using?

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

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