# Matrix - Identify Cell Content In Column For Row If Matrix Content True?

Mar 21, 2014

For a table like the one below produced for the sake of example (actual is much much bigger) I want to make it list rows that are true for a certain column for a certain variable in the matrix. So for say water terrain, which types of activity can I do i.e. swimming. Or for Offroad the activites which I can't do i.e. Run and Swim.

Jog nym
Run nyn
Walk nyy
Swim ynn
y=yes
n=no
m=maybe

## Finding Row And Columns For All TRUE Values In A Matrix

May 21, 2013

I'm using multiple data tables to run sensitivity analyses on a very large model. At the end of the analysis, I've got a matrix that tells me which scenarios are TRUE or FALSE (based on multiple criteria). I'm looking for an elegant way to extract the combinations that give TRUE.

Column1
Column2
Row1
FALSE
TRUE
Row2
TRUE
FALSE
Desired Output
True Scenarios:
R1, C2
R2, C1

Sep 12, 2007

I use this to read cell content, add some text/characters (ie. [ and ]) and change the properties of the complete cell

Sub COMMENT()
Worksheets("DVD Lijssie").Activate
If ActiveCell.Value 0 Then ' Change all in to ... ... ...
ActiveCell.FormulaR1C1 = ActiveCell.Value & " " & "]" & " " & "["
With ActiveCell.Font
.Name = "Arial Narrow"
.Size = 8
.ColorIndex = 16
End With
End If
End Sub
HOW can I change this vba-code so it leave's the content of the cell like it is and add some content with the use of let's say TexBox1 and ONLY use different font properties for the newely added content?

## Creating Adjacent Matrix From Incidence Matrix

Aug 26, 2007

I have a data chart on 200 people with overlapping membership in 20+ groups, represeted as binary (1=member, 0=notmember), for example: ...

## Return Inverse Matrix Of Large Matrix

Aug 22, 2008

Using VBA, I wish to work out the inverse matrix of a large matrix (100*100), but keep getting the # Num! Error. I am using the minverse function. I have defined variable as "variant", does this give me the same possiblities in terms of number size as the variable "Double"?

## Change Content Of One Cell Based On Content Of Another

Apr 18, 2014

Formula/macro/etc that would enable me to have content of a cell changed based on the content of another cell in the same row.

Example: cell in column D says "PSA" - so I would need the cell in column H for that same row to read "Radio"

I would need an entire sheet scanned to review for these occurrences and make the appropriate changes. I also would need the formula to be inclusive enough to scan for variations in column D cell content (PSA 1, PSA 2, etc).

## VBA / Word Picture Content Control Causing Unreadable Content?

Jan 15, 2013

I am using VBA to create a word document (.docx). This word document contains plain text content controls as well as picture content controls. I then use VBA to automatically select a picture based on the code below

Code:
Set oCC = Word.ActiveDocument.SelectContentControlsByTitle("TabPic").Item(1)
On Error GoTo TabErrorHandler
oCC.Range.InlineShapes.AddPicture Filename:="X:XFERANDREW-TDCD " & LblVL &

[Code].....

After the document has been closed down I try to open it again and I am told "The file cannot be opened because there are problems with the contents."

When I click details it says "Unspecified error" and "Location: Part: /word/document.xml, Line: 2, Column: 0"

If I click ok it says "Word found unreadable content in "". Do you want to recover the contents of this document? If you turst the source of this document, click Yes.

Clicking Yes opens the document with all the contents and it is now renamed to Document 1. If I click no it does not open.

## Merge The Content Of 2 Cells Into 1 (with A Comma Separating The Content)

Jan 29, 2007

how to combine the content of 2 cells into one cell and have the information separated by a comma.

For example:

CELL 1:
Software 1

CELL 2:

The desired results is:

CELL 3:

## Create Matrix From A Matrix

Apr 29, 2013

Below there are all the information needed to understand my problem.

M(1 to R,1 to C): matrix with R rows and C columns [element known]

M(i,j): elements of the matrix M in position i(row)-j(column) [element known]n

## Move The Content Of Cell From One Column To Other

Aug 21, 2007

I want to enter a number 0 to 999 in cell A1 and when the enter key is pressed move the contents of cell A1 to A2 and A2 to A3, cascading down until A40. So after five numbers the first number I entered woul now have cascaded down to cell A5 ready to go into cell A6.

Would I have to use some kind of program or does excel have a command for this?

## Does Cell Content Exist In Column

May 18, 2007

I do have a problem with my excel sheet. i have a workbook with 2 sheet which i need to compare a colume of data from sheet1 with sheet 2 colume M2. If it is matched, then sheet 2 colume BJ2 will return a "F" else "N"
So i was thinking of using an If formulae: =IF(M2=sheet1!A2:A16),"F","N") but somehow the above text return a msg of "A16" is invalid. and i tried to used VLOOKUP by defining the mapping sheet as "KEY"

=VLOOKUP(M2,KEY,A2)

and i copy and paste the above formulae to the remaining column M for comparison. Somehow, this did not work as well.

## From Matrix To Column!

Jan 29, 2009

I NEED some code to convert a matrix to a singel column and it should be reversed to!
see attachment!

example:

FROM:

A1 B1 C1 D1
A2 B2 C2 D2
A3 B3 C3 D3

TO:

D1
C1
B1
A1
D2
C2
B2
A2

## Matrix To Column..?

Nov 23, 2009

I have this code to take an area of data and perform the SUMXMY2 formula and output the results to another sheet. My problem is that the results are being outputted in a semi-matrix and i needed them in a column so i can them perform a sort. Is this possible and can anyone shed a light on the best way to do it?

## How To Lookup Row # Based On Content Of Another Column's Cell

Oct 24, 2005

I have a 3 column table with 20 rows. The first two columns contain travel
expense data. The cells in the third column are blank exept for whichever
cell I enter an "x" in. Please let me what formula or worksheet function do
I use to calculate the travel expenses based on the data in the first two
columns that correspond to the row of the cell with an "x" in the third
column?

## Matrix To Single Column

Jan 2, 2006

I have an array of data with column headings and changeable row "item names"
in the left most column. The intersecting matrix of data contains quantity
values at the intersection cells of column and row headings. I need to
automatically reorganize the data as a list in a column with the row "Item
Names" at the left but and repeated as necessary but instead of the
additional columns of quantity values, I need to have this data listed in a
single vertical column along with an additional column with the original
column header that corresponds to the quantity value. I think there must be
some kind of lookup function to do this but I can't find the right way to do
it.

## Match Cell Content With Another File And Return Value From Next Column Over?

Sep 29, 2013

I have two files. They both have US census tract numbers in a column GEOID2010. One also has a CSA2010 text description associated with each census tract.

I need to match the cell with a census tract in the first file (example1).xlsx with the census tracts in the second file (example2.xlsx), and then return the CSA2010 text from the next column over to the first file.

I've attached two example files.

## Reformatting Matrix Into Single Column?

May 27, 2014

I have a matrix that looks like this:

1
2
3

4
5
6

7
8
9

10
11
12

And would like to rearrange this data to:

1
2
3
4
5
6
7
8
9
10
11
12

In actuality it's a 110000 x 3 matrix that should become a 330000 x 1 column.

## Converting A Matrix Into A Single Column

May 5, 2008

I need a macro that allows me to select a matrix of cells and converts it into a single column elsewhere, pasting the second column below the first and so on. Is it possible to select the matrix, hit a macro key and then paste it in my selected location?

## Minimum Value From Specified Column Of Range Matrix

Mar 5, 2008

I have a 10x10 array that represents different cities that a travelling saleperson can travel to. Rows are cities designated as i values, columns are the same cities and represented by j values. I need to use a For, Next loop to determine the shortest distance (lowest value) in a given column. The i (row) that contained the lowest value is the first city to be visted and a boolean is entered for that j=i column, showing that the city has been visited. When pulling the minimum values from the column I need to ignore 0 values where the distance is between a city and itself. I'm having trouble coming up with a loop that takes identifies the i row with the lowest value that also ignores previously visited cities and takes the boolean into account. Maybe my Excel spreadhseet will clear up what I'm trying to do, The distances were generated using RANDBETWEEN(1,100).

## Checking For Unique Value In Matrix And Group Column Value Assigned

May 16, 2014

I'm working on a sheet I have to complete and I'm blocked 'cause I'm not able to find the right formula to get the result I need.

I have a sheet that contains 4 columns with the following content (consider the following just as an example. The real sheet contains more that 25,000 rows.

User ID Repository 1 Repository 2 Repository 3
001FG x
001FG x
10GA x
20PK x
20PK x
20PK x
21CC x
4C1D x

Now, the table contains the user id (unique ID) and three columns that stand for the access right the user has for accessing a specific repository.

This means that a User can have more than one occurrence in the sheet because it could have rights to access different repository (i.e. the user 20PK can access all the repository).

What I should be able to do is to transform the table above to a new one with unique user id and the rights for each repository. I would need something like this:

User ID Repository 1 Repository 2 Repository 3
001FG x x
10GA x
20PK x x x
21CC x
4C1D x

How can I do this by using a formula and not a macro?

## Concatenate All The Cell Content From A Column In One Cell

Feb 27, 2007

I would need to concatenate all the cell'content from a column if the value is different from null ("") in just one cell separated by ";" ... By ex :
In column A I have :
A1-""
A2-X
A3-""
A4-y
In cell B1 I should get "X;Y"

## Picking Matrix Cell Using Dropdowns?

Mar 26, 2013

I am trying to get excel to pick a cell from a hiden matrix and showing it on my worksheet. I want to pick the cell using 2 drop down boxes as bellow - 1 drop down picks option on X axis and the second picks using the Y axis and then the coresponding cell in the matrix is displayedMatrix example [URL] Drop downs example [URL]

## Compare Each Cell In Matrix. Different Workbooks

Nov 10, 2006

I have a vb script used to compare a 3x3 matrix cell. My idea is to compare each cell by each cell. My 1st input is xx1.txt shown below

123
456
789

My 2nd input is xx2.txt shown below

1893
456
7810

I am expecting to get the below output with 89 and 10 highlighted in red because these are the difference between the 2 inputs and the rest of the numbers highlighted in green

1893
456
7810..................

## Cell Selection And Data Entry In Binary Matrix

Jul 4, 2013

I've set up a binary matrix, such that I have 421 unique headings repeated twice: once in each column and once in each row (i.e., in the matrix the headings for row 5 and column 5 will trace back to the same description in the column headings and in the row headings).

I need to fill in 1s (case satisfied) or 0s (not satisfied) in this 421X421 matrix. Where my problem lies is in finding the exact row-column cell combination in which I need to enter the 1s. Descriptions that belong to the same group or category will be marked by these 1s in the matrix. For example, if I have descriptions 5, 9, 13, and 17 belonging to the same group I need to enter a 1 in each possible combination of these numbers: {5,9} {5,13} {5,17} {9,13} {9,17} {13,17}. I need a quick formula that will compute all possible combinations for inputted descriptions AND will enter a 1 into the cells, which correspond to these combinations.

## Sum One Column Based On Another Content

Jun 9, 2014

Sum A1:A100 only for corresponding B1:B100 containing "paid". translate that to a formula? I don't know conceptually how to approach it.

## Excel 2010 :: Value To Cell Based On Horizontal And Vertical Data On Matrix

Jul 30, 2013

I have chart like below. In empty cells I want either 1 or 0 (1 if software is installed and 0 if not).

Excel
Outlook
Powerpoint
Word

Computer1

Computer2

Computer3

Computer4

Computer5

Data of computers and their software are like this:

Computer1
Word

Computer1
Excel

Computer1
Powerpoint

Computer1
Outlook

Computer2
Outlook

Computer2
Excel

Computer3
Outlook

Computer4
Outlook

Computer4
Excel

Computer4
Word

Computer5
Outlook

So called Matrix Lookup was very close, but it finds data FROM Matrix (aka that first table). Is it possible at all?

Excel and Windows version:
Excel 2010 SP1
Windows 7

## Deleting Partial Content In A Column

Mar 9, 2009

I have a sheet with 3 columns, A B and C

column B has content such as:

term 1 (c: text a)
term 2
term 3
term 4 (c: text b)
etc.

desired output:

term 1
term 2
term 3
term 4
etc.

Can someone create a macro for me to delete the (c: ...) in Column B but leaves all of the other column data alone.

## DELETE Row Based On Content Of Column

Jan 8, 2008

Need macro or other code that will examine a column in my my table for particular text (example: find text: "Total") and then DELETE the whole row that the cell containing the text is in.

## Convert Values / Content In One Particular Column To Individual Column Heading?

Jan 29, 2014

The yellow highlighted column F (each Reason) in the sheet2 to be placed as main header in the next column and so on as seen in the sheet 3

If they have two similar item number with 2 different reasons - delete the duplicate item number and place the number in each column according to its reason as seen on row 16 on the sheet3

If they have two number with similar reason - just sum up the number

sample excel 2.xlsx

## Duplicating Rows Depending On Column Content?

Jul 18, 2013

Im replicating rows which have multiple items in Column1. Im aware that the ID Column has duplicates..my source data is like that for now so I wont complicate it just yet.

Once ive got this working I can proceed to the rest of the tasks