matrix

I have an expense form that includes a mileage chart. I have "From Branch" and "To Branch" columns, each of which uses the same list of branches as data validation. <tbody> From To Mileage Main Ditch Road 12.51 The Other Branch Main 16.86 </tbody><colgroup><col><col><col></colgroup> I...

(Like many of you) I've been given a task to update an externally-created spaghetti-link spreadsheet. In this case it is a pro-forma to estimate the cost-per-pound of linen going through a proposed laundry. In essence it is a series of matrices through which the linen volume moves. First is a...

Hello - I have been racking my head trying to figure this one out... Lots of google searches and searching MrExcel have left me still wondering. I have a matrix in excel where the top header is general ledger accounts and the left hand column is locations. When the two are combined you have a...

Hello, I am trying to make a function which would use a matrix of (N ,2) dimensions. The function (incomplete) is as following: Function APPROACH(P1 As Range, x1 As Double, y1 As Double) As Double N = P1.Rows.Count Dim A1(1 To 3, 1 To 3) As Double Dim A2(1 To N, 1 To 2) As Double I get an...

I have this code to get the smallest number that can find and his column in each row of the matrix and write it in cells(column where it was found, row) This is the matrix at the beginning https://i.stack.imgur.com/Ufn5V.jpg I execute the code and this is what happens...

I have a problem where I need to reference a cell in a matrix, and then I need to be able to copy both the reference cell and the matrix to a new destination (either a new spreadsheet or shuffle it around a few cells) but keep the relevant references in the matrix. So as an example (see image)...

Hello guys I was wondering if anyone might be able to help me with the following problem. I have a table that has data by weeks. I want to create a reference that lists each week by month or even quarter and then perform statistical calculations (min, max, median, etc) to the data that meets...

Hi, I have a fact table (many) and a dimension table (one) with a relationship set up between the two. I have created a matrix that is bringing values (product descriptions) in from the dimension table (as 'Rows'). I have then created a measure using data held exclusively in the fact table...

My Table looks Like 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 I need to Convert it to a single column with no spaces, i.e. 1 2 3 4 5 6 7 8 etc Please Help

Hi, I'm trying to work out how to get a symbol to pop up in a cell when two other cells contain a certain value. For example: If A1 and B1 contain x and y combination, C1 has a rule attached that inserts a particular symbol or text (doesn't matter what) for that particular combination. I'm...

(i) Develop an algorithm to determine whether a graph represented by a node-node incidence matrix is connected or not. Provide a clear algorithm statement. (ii) Code your algorithm in any programming language you prefer, run your code on the node-node adjacency...

Hi, I need to get the list of training records for a particular employee from the overall employee training matrix in different sheet. Attached the requirement in sample sheet. sheet 1 (data) is the training matrix and sheet 2 (summary) is where I need the formula to retrieve the info based on...

Hi, I have a table with ID numbers that repeat in some sections, in each of them, it will have a different K value. There is 3 possibilities, 0 indicates INPUT (IN), the maximum value is LATERAL OUTPUT (OUT L) and the middle one is DIRECT OUTPUT (OUT D). How can i do this?

I have a UDF for correlation matrix (enclosed); can it be modified to replace the non-result 0's (zeros) with "n/a"? For example, When I use the function I get a 1-sided correlation matrix for -- - data: <tbody> x1 x2 x3 x4 1.0000 1.0000 2.0000 4.0000 4.0000 3.0000 4.0000...

Hello, this is my first thread but I have been reading and learning since months if not years. Now I'm stuck with this problem and I can't find a solution on my own. I have a binary table like this: <tbody> A B C D 16C 0 1 0 0 51C 0 0 1 0 17A 0 0 0 1 39A 0 1 0 0 24C 0 0 0 1 16A...

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

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

Is it possible to have a user choose a value from a dropdown box outside a pivot table (which matches an existing pivot table field) which places that column into the pivot table rows area? I have a matrix table with 4 main column headings (ABCD) that i can place into my pivot table rows area -...

Hi a b c 1 5 2,5 Yes 2 5 1,5 No 3 6 3,5 Yes 4 5 4 Yes ... 124 I will sum column b if column a = 5 and column c=Yes Result = 6,5 (2,5+4) I tried this with (control+enter to make matrix) =IF($A$3:$A$124=5;SUMIF($c$3:$c$124;"Yes";$b$3:$b$124);0) This did not work. Please give me...

I need some help/suggestions with an analysis I am performing based on product serial numbers. Background: I have a spreadsheet of 500 or so serial numbers for one of our electronic products. The serial numbers cover 4-5 different model numbers. Each of these models contains 30-50 pieces of...