matrix

Hi, I have morkowitz portfolio in excel. I want to convert the covariance matrix into VBA. Can anyone help me. Regards, Narendra

Hello everybody. In a cell I have a matrix correctly set up that copies a value of another cell. Suppose, for simplicity: {=MAX(B5:B10)} But in effect I need the value in the cell next to left: so, if the max value is B7, i need the value in A7. How can I instruct the formula? Thank's.

Hi all, I am working on a matrix consisting of multiple names matched to values. I would like to give everyone a specific RGB colour value (on different sheet). This way, one can easily recognize one another by colour (in addition to names and values in the cell). At this moment I have a...

I'd like advice how to do the following reports. I need summaries of matrices as 3 time period columns by 5 class rows for each matrix sheet on a sheet. My matrices are 10 class columns with 24 time period rows containing integer values. The matrices are within separate existing sheets of...

I would like to rank a matrix by value (with corresponding name) per time period. Also, as the matrix will be a bit larger, I would like to indicate every person with a different color. That way one can easily see how each and everyone performed over time. So in the result, the background of...

Hi there. I'm making a little model to build up a cost based on a number of list ranges with look ups to a pricing database. I want to be able to look up whether a selection is valid based on a logic matrix that I have made. To do this, I have created a table in the following style...

Morning all. I need advice on where to start with a project/idea I have had. I have an excel document which is a training matrix, which contains all the staff details for over 300 staff (that number is growing continuously). Each of the staff have a clock number which is in cell B8 downwards...

Dear all. I am reading a book "Credit: risk modeling using excel and vba" and came across the code below (only part of it) that creates a function for logistic regression. I have some understanding about VBA but I have never used matrix and it seems that the code starts to create a dummy...

What is the best way to do the following: If one (or more cells) within a range on a matrix is marked (e.g. with "X"), show the value of the header in that column in the cell of the corresponding row left in the matrix (column B in my example). If more than one cell (on a row) is marked, the...

Hello all I'm very very new to VBA. I checked internet forums to find a similar case and tried to modify the program as per my needs but I'm not satisfied with my work. I need your support to do this. My case: I have a matrix 21 rows * 30 columns with drop-down list on all the cells, user...

hi all i understand how to work Vlookup funciton, if found a value return me a value, if not give me a #NA (right) my dude is how to mark in the matrix the value? see the image. https://imgur.com/a/LkFjp1C How to mark? found in the matriz? thanks

hey anyone have samples or a ebook to buy about Matrix formulas? thanks

sorry for Spanish version of Excel BUSCARV=VLOOKUP EXTRAE=EXTRACT https://imgur.com/a/IBN2w here the image... se point 3, this formula point directly to a value(cell D4), and find it in the matrix in the point 2 i extract the value from a String (get same result as cell D4): 40000005 but not...

Hi to all Good Afternoon I got genetic distance matrix based snp genotyping data of 10 individuals in matrix format and now I want convert it into data frame format like genotype1 in columnA and genotype 2 in column B and distance between them in column C and also rank them genotype wise for...

Greetings, I have a correlation matrix macro that I use to find correlation values for pairs of data. The macro seems to be working fine, but some of the matrix cell values are left blank. The blank sections are associated with specific parameters and hence leave entire columns and rows...

I'm trying to create a scenario matrix for sequences of 4 constrained outputs. For each scenario below, I have a maximal number of laps completed by each rider (9), a minimum number completed by each rider (0.5) and the number of laps completed by each rider can vary in increments of 0.5. The...

I have an occurrence matrix made from a set of sample data. The data represents a series of stores, and a series of items held at each store. There are over 6000 unique store locations, and around 400 unique items. The occurrence matrix maps whether the item is at the store. In the sample...

Hello, I need to create a matrix style table from my data set similar to this: <tbody> Category Sub Category Product Name Product Detail Product Detail Product Detail Product Name Product Detail Product Detail Product Detail Product Name Product Detail Product Detail...

I have a problem regarding to excel binary combinations. As you see there is a matrix (Matrix 1) with the values of 1 and 0. --- represents N/A or 0. I want to get all different combinations without changing the sums. Matrix 1: <tbody> Sum --- 1 0 1 0 2 1 1 1 1 0 4 1 0 1 --- 0...

Hi, I have a UserForm and a Label. When the Userform is open. I want the Label to Display: "Welcome to Mining Matrix" but the word Matrix comes from different Worksheet. so meaning you can change the word matrix from that sheet. Thanks in advance