matrix

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

    Disable button until cell edition is finished?

    hI, I have a file with data matrix table in one of the sheets. There is also button that does the calculation and presents the report placed in other sheet, but only if user change some data in matrix (recalculation takes some time, so I do not want to do it, if no changes in data matrix have...
  13. M

    Matrix matching function

    I created an x by y non-symmetric matrix in which, for values 1-5, "O" denotes a "preference to match". A "match" occurs only if both values reciprocate the preference (1 and 2 are a "match" because both prefer the other, while 1 and 3 are NOT a match because the preference isn't reciprocated)...
  14. M

    index match match - VBA code loop ignore if cell contains data

    Hi, Apologies.. this might be a bit vague, I'm looking for suggestions if possible. I will have a large matrix - may be 200 x 1000 To simplify the above, imagine I have a matrix of 3 x 3. Across the top (as headers) are account numbers. Down the left side are product codes. On sheet 2, I...
  15. L

    Continuous column array from a non-complete 2d matrix array

    I have a 2d-matrix array but not all cells contain data. I need a formula to map all of the non-blank data to a continuous column (by rows of the matrix). I found the following online, which works perfectly except the output includes the blanks from the source matrix...
  16. C

    Matrix VBA

    Dear All, I have been trying to work on this VBA question: You must now create a user-defined function that will take two parameters of type range (two matrices mat1 and mat2). The function returns a matrix C in which each element is equal to the max value with the same coordinates in mat1...
  17. M

    Excel Queries to create a matrix?

    Good Afternoon All, I'm trying to put together a spreadsheet matrix with a "item name" on the Y axis and "Gift Name" on the X axis. Each gift comprises a number of items within one gift. Both axis information is held within 2 separate worksheets within a source file workbook. I have used...
  18. C

    VBA to convert a Tabular Report to a Matrix view

    Hi Everyone, I have a report which I generate on a regular basis and need to convert from a tabular view to a matrix view for readability. I use Excel 2013 I would appreciate if anyone could assist me with some VBA code to accomplish the following: Delete all non-required columns, in this...
  19. T

    Matrix addition of overlapped quadrant

    I am trying to solve an engineering problem using matrices. I know some programming in VBA but not alot, this problem has puzzled me for quite a while. So any idea will be much appreciated. Each of [4 x 4] matrix is generated based on the parameters of the equation, but for the purpose of easy...
  20. M

    Calculate Rebate % Based On 2 Criteria - Sales Volume & Compliance Ratio - INDEX/MATCH?

    I need to calculate the Rebate % earned based on two criteria: sales volume & compliance ratio - the 3 columns I'm trying to complete are in red: Tier, Rebate % & Rebate Amount. Question: What is the rebate amount for customer 121761 for September? Sales Volume is over $100K and Compliance...

Some videos you may like

This Week's Hot Topics

Top