matrix

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

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

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

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

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

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

Hi All, This is my first post here and hope will get my answer here. I have a table with 3 columns, store, Weighting and matrix. I need the unique store list from the table but weighting and matrix columns should be added or concatenated before deleting the duplicate rows. Please find the below...

Hi, What formula would be best for a "3D" style SUMIF, to allow a matrix of values to be summed, as in the example below (sorry I can't get the image function to work, so it's a link instead). https://imgur.com/13Pda1w James.

Hi, I need some help to put the following data into an excel pivot so that I can look at any Oracle Role and see only those responsibilities that apply (ie where the X exists - I don't want to see any of blank cells_). Is there a way of doing this? A regular pivot does not seem to...

Hi All, I know how to use the Index and Match functions for pulling out data from a matrix. Could you please help and advise on how to combine multiple Index Match functions for one cell across multiple sheets of matrix. I searched online couldnt find any solution to this. What I need my...

Hello, I have a spreadsheet with different skills listed as column headings in the table I named "Train". I would like to be able to double click on any of the column headings and have my table filter on all non-blank cells. The rows have trainings listed so the table is full of x's that...

Hello Guys i have a big question. I need some help for VBA-Code. I have got a workbook with nine worksheets. All worksheets have the same structure. I would like to categorize these worksheets by adding the sheets. Those Worksheets called: Worksheet 1 = called T1 Worksheet 2 = called T2...

Currently Matrix table on Report is displaying values in 2 decimal places. How can we round it to 0 decimal place? I look up web resource they ask to use DAX to round but since many rows are 0.2 something, rounding at DAX row level will make them zero but I want to round only at report summary...

Hello all, the "problem area" is highlighted in Bold. We've tried extensively to fix this including aliasing all sheets and variants of "ActiveWorkbook.Activate" Sub Produce_Report()' ' Produce_Report Macro ' ' Application.ScreenUpdating = False Application.Calculation = xlManual Dim F...

Hi all, I'm trying to do, essentially, a triple lookup. I've got 14 Matrices, and I want to select one of the matrices, a vertical value from the selected matrix, and a horizontal value from the selected matrix, and get the intersecting value. I've already got down the VLOOKUP/MATCH pair for...

I have a huge parts sheet with thousands of rows and columns, cross-referenced to a master parts list. I attach a small sample: <tbody> Generic part finishing description part 1 part 2 part 3 part 4 part 5 part 6 part 7 part 8 part 9 part 10 128 0-008 73110 0002SC1383 0002SC968P...

<tbody> AMOUNT 1 AMOUNT 2 220000 154 153000 1001 74000 2521 756349 3256 122000 4566 856746 1566 444352 816 212158 612 346777 315 </tbody> Hi all, I need a little help with a matrix and formulas inside. I have 2 columns - AMOUNT 1 and AMOUNT 2 and I need...

Hello, In vba, is there a way to use "application.worksheetfunction.min()" to find the minimum of a vector Inside a matrix. Exemple Data(1 to 3, 1 to 20) as variant Inside my Data(1,: ) i have dates. I would like to easily find the minimum date. Thank you!

Hi, I have a request if anyone can help. In 1 Worksheet (WorksheetA) we have a large matrix of data where each cell is being be calculated using large formulae. Similar to the example below but a lot more data: <tbody> A B C D E 1 20 21 22 23 24 2 25 26 27 28 29 3 30 31 32 33 34 4...

I am struggling with standard deviation in a sumproduct() output. I have developed a matrix that tracks stuff by hour of day and day of week over the course of a great length of time. This matrix is specific and by design. Right now, I am able to achieve a total count, and an average count...