matrix

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. C

    Lookup between a range

    Hi All, I'm wanting to lookup a value from 2 separate cell values one being height and the other width - to find a match in a pricing matrix. If this can be done at all. E.g - 717 x 448 = $36.06 <tbody> <tbody> Qty Height Width Price EA Price Total 2 717 448 3 357 405 3 357 405...
  13. O

    How to take values and populate a matrix using Find Method

    I'm not too familiar with the Find method as I've always used For loops, which take way too much time. What I'm trying to do is go down a list of over 400,000 values in four columns and then take three of those values to determine where in a matrix the fourth value should be placed. For...
  14. B

    Matrix Table - Add Column to the end of the Matrix (not on every column)

    Hey Guys, Looking for some help here - I havent been able to find a solution anywhere. I have a matrix table that provides a view of aging inventory. For each client they have a number of days to work the ticket before it is outside of SLA. I want to add a column that shows when those...
  15. S

    Pull GL Coding from Transaction Matrix of Cardholders and Shortened Vendor/Transaction Data

    Hello! I'm trying to create a "transaction matrix" of sorts for expediting the AMEX statement at the end of the month. I've got columns designated for my full employee's names, with rows going to shortened purchase names. For instance, "Uber Xasdqb239871-0-X" was shortened to just "Uber". I...
  16. G

    Standard deviation of correlation matrix

    I am looking to get the standard deviation of each correlation coefficient in a matrix. The matrix is complete (as in each pairwise correlation in included twice) but i want the standard deviation including only each coefficient once. The matrix will vary in size and can be quite large so i...
  17. C

    How to get the address of the formula's result from 2D array (Matrix)

    Hi everyone! I have stumbled upon a problem while trying to extract the address of the formula's result. Namely, I am talking about the formula that calculated minimum value from the matrix based on the different criteria. The matrix that I have created is simplified just for the purpose of...
  18. L

    Create Matrix, exhaust the excess funds and avoid circular references

    Dear All, below is by far the most complicated case I've ever encounter. Hopefully, that is not the case for you and you will be able to help me solve this. Table 1 and 2 are supposed to be Matrix of Stand Top Tool Type and Stand Code Description. Table 3 is the data set where the relationship...
  19. S

    Adding multiple columns in Matrix columns

    Hi All, I am new to power BI and I have requirement to do in power BI where I need to show the some of key metrics in matrix format. Here is the my requirement. Well I am working for the Textile company where in I need to prepare the reports using Power BI and unfortunately I could not make...
  20. S

    Adding multiple columns in Matrix columns

    Hi All, I am new to power BI and I have requirement to do in power BI where I need to show the some of key metrics in matrix format. Here is the my requirement. Well I am working for the Textile company where in I need to prepare the reports using Power BI and unfortunately I could not make...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top