How To Covert Lower Triangle Of A Matrix To A Single Row

Mar 28, 2013

I have a 22x22 matrix with correlations; I want to extract the lower traingle as a single row; so my matrix is

# r1 r2 r3 r4 r5 etc
r1 1 0.5 0.3 0.7 etc
r2 0.5 1.0 0.5 etc
r3 0.3 0.5 1.0 etc
r4
r5
etc

I want my row to be

r11 r12 r13 r14...r1-22 r21 r23 r24 etc..

View 5 Replies


ADVERTISEMENT

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.

View 13 Replies View Related

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.

View 6 Replies View Related

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?

View 11 Replies View Related

Copying Formula To 8 Cells Lower With Result Of 1 Cell Lower?

Sep 30, 2013

create a formula copying a formula from cell a5 to a20 but i want the result to be 1 cell lower from a5's result

View 6 Replies View Related

Code For Triangle

May 11, 2007

In the attached file, there are three sheets: Data and Private. Sheet Data contains data source. I want to try to covert the data in sheet Data into Private in triangle format.

For example, Sheet Data range A1:A5 will be converted into the latest diagonal in sheet Private range A1:E5.
Sheet data range D2:D5 will be converted into the second latest diagonal in sheet Private range A1:E5.
Sheet data range G3:G5 will be converted into the third latest diagonal in sheet Private range A1:E5.
Just follow the step, there will be a triangle range A1:E5 in Private. Same thing, there will be another triangle in Private.

During the past few years, I use an Offset/Row/Column formula to create a triangle. I feel code can do the same thing because the data structure follows a kind of pattern. I tried and failed.

View 6 Replies View Related

Change Data Into Triangle

Dec 5, 2006

Sheet1, there have data in A1 (100);
Sheet2, there have data in A1 (200) and A2 (300);
Sheet3, there have data in A1 (400), A2 (500), A3 (600);
Sheet4, there have data in A1(700), A2(800), A3(900) and A4(1000).

Now I want to use For Loop code to copy the data in Sheet1 through Sheet4 and paste them in Sheet 5 beginning with A1 into a triangle format:

100 300 600 1000
200 500 900
400 800
700

View 9 Replies View Related

Calculate The Length Of 2 Unknown Sides Of A Right Triangle

Mar 27, 2009

I need to write a spread sheet that will calculate the length of 2 unknown sides of a right triangle using the following information.

Here is what I know
1. I have a right triangle
2. I know the length of the hypotenuses
3. I know the ratio between the length of the other 2 sides

I need to write and Excel file that will solve for the length of the other two sides

The math look like a^2+b^2=c^2

with c being known and the ratio between a and b known

View 9 Replies View Related

Cell Has Triangle Markings Where Formulas Exist

Sep 23, 2006

I sent an excel file to a friend. When they opened the file a half triangle mark appears in any cell where there is a formula. How do i get rid of this mark?

View 3 Replies View Related

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

View 9 Replies View Related

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"?

View 9 Replies View Related

Determine Values In Cells: Get The Lower Values Between To Cells And Have The Lower Valued Cell Highlighted

Oct 27, 2009

I M trying to get the lower values between to cells and have the lower valued cell highlighted,,,i have over 43 thousand lines of data to go throughand i was wondering if there was a quicker way to do this,,,for example cellA1 is $4.25 and cellA2 is $5.25 i want cell A1 to be highlighted,,is there a way?

View 2 Replies View Related

Create Triangle That Will Adjust Angle-size When User Edits?

Sep 12, 2012

I have a matrix that calculate lenght of the sides in a triangle, this is for the purpose of a camera and the pixelsize/inchsize.

Is it possible to create a chart that will give the user an visual control on how the cameras detection area looks like?

View 2 Replies View Related

Plotting Circles On Vertices Of Triangle Governed By Cosine Rule?

Mar 9, 2013

How to plot circles via vb. Basically I would like to plot circles on the vertices of a triangle with the following data.

1) length a = 69, b=103, c=119.9967, angle between a and b =86.1. (These values are determined from the cosine rule)

2) Diameter D1=40,D2=98, D3=108

See link of circles : IMAG0176.jpg

View 9 Replies View Related

Covert Into A Date

Oct 27, 2008

I have a long list (+1000 entries) of numbers (that actually represent dates) in cells one under neath another.I need to get them into date form so i can arrange them from earliest to latest.

Kind of looks like the following:

Cell1 - 1122005 (which i supposed to represent 1/12/2005)
Cell2 - 10192005 (.......................................10/19/2005)
Cell3 - 9282005 (.........................................9/28/2005)

Right now Excel just sees a bunch of numbers and does not know what to do with them.

View 9 Replies View Related

How To Covert Email Macro

Oct 22, 2013

I am trying to insert a macro to send myself an email when ever someone uses my spreadsheet (I'll embed the code in an existing macro).

The reason for this is to not only gauge who/how many people are using it but also make sure no one is using it externally (I suspect people are passing it on to people outside the company which they are not supposed to). I need it to be covert so I don't tip them off and they don't start circumventing this check.

I have found the below which works well, but I wanted to see if there could be some additional checks to better conceal the sending of an email.

Can I also somehow check the Outlook status to make sure it is working "online" so the email doesn't sit in their Outbox if they are not connected to the network/LAN?

Code:

Private Sub Workbook_Open()
Application.DisplayAlerts = False
Dim oApp As Object 'Outlook.Application 'Object
Dim ns As Object 'Namespace
Dim fldr As Object 'MAPIFolder
Dim mItem As Object 'Outlook.MailItem
Dim sendTo As Object 'Outlook.Recipient
Dim bOutlookFound As Boolean

[code]....

View 1 Replies View Related

Covert A Word Document

Jan 25, 2009

I need to covert a word document to excel.

View 9 Replies View Related

Covert My Currency (Rupee) In To Million

Oct 7, 2008

Will some one guide me, How can i covert my currency (Rupee) in to Million?
(2700000 Rs Into Million with formula/automatically)

Secondly,
Can i make in a specific cell 4 colums & 2 rows ? Is it possible. ?

View 9 Replies View Related

How To Covert The Value Of A Checkbox From True/False To 1/0

Dec 24, 2008

I have searched all through the threads but I can't find anything similar to my problem. I am trying to create a checkbox that when the excel file would be saved as a *.csv file, the value for the checkbox would be saved as an boolean value 0/1. I created a macro that would populate the cells with the form control checkbox and linked it to the respective cell, I just need to change the value.

View 9 Replies View Related

Covert Numeric Value To Alpha Code

May 23, 2006

I've tried searching the forum here, but have not seen anything like my problem as follows:

I would like to convert the numeric value in a cell to a coded alpha

the numbers 1,2,3,4,5,6,7,8,9,and 0 would be coded as B,L,A,C,K,H,O,R,S,E respectively.

For example, if cell A1, held the value of 5750, the formula in cell A2 would result in KLOE.

The figures in Col A would be no smaller than 3 digits nor larger than 5 digits.

View 5 Replies View Related

Covert Decimal Number To Minutes

Aug 11, 2006

I would like to convert a number to minutes. For example .48 or 48 as a formula result to 48 minutes. The reason for doing this is I will add the result to a time.

Forumula result = 48 -> convert to {48 minutes + 12:00 = 12:48}

I've tried using just formating but no luck.

View 9 Replies View Related

Covert Space Delimited String To Array

Apr 24, 2008

I have two columns of data, one for Position, and one for description.

The positions are concatenated and separated by spaces. E.g. C1 C2 C3 for each Description. I need to create a separate row for each position

So I need to convert:

Pos Decscription
C1 C2 C3 Cap 100n 10% X7R 0805

to:

Pos Decscription
C1 Cap 100n 10% X7R 0805
C2 Cap 100n 10% X7R 0805
C3 Cap 100n 10% X7R 0805

Or in other words split a space delimited string into an array, so that I can loop through the array, and add new rows

View 9 Replies View Related

Covert Duration Between Start And End Date To Units

Oct 1, 2013

I need to formula to covert duration between start date and end date to units below.

Start Date
End Date
Number of Month
Number of Years
Number of Days

6/1/13
8/31/13

[Code] .........

View 6 Replies View Related

Covert Formula To VBA Loop To Fix 5 And 6 Digit Time

Oct 10, 2013

I use this code in Column M to convert Column N

Code:
=IF(LEN(N2)>

I am looking to loop down Column N & O and replace , insert colon for both column N and O I started with is code

Code:
Sub FixTimeFormat()
Dim TimeNumcol As Integer
Dim ConvertedTimeCol As Integer

[Code]....

View 4 Replies View Related

Covert Number To Date 20131126 To 11/26/2013?

Jan 1, 2014

Covert number to Date 20131126 to 11/26/2013

View 7 Replies View Related

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.

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

View 10 Replies View Related

Only Allow Upper/Lower Case Not All Upper Or All Lower

Oct 8, 2008

Is there a data validation that will not allow all upper case or all lower case characters?

For examples:

Allow:
John Doe
101A N Woodbine Street

Disallow:
JOHN DOE
101A N WOODBINE STREET

Disallow:
john doe
101a n woodbine street

Or perhaps formatting that would convert the words to upper/lower case?

Or, I would be interested in VBA if it is the only way.

View 9 Replies View Related

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

View 3 Replies View Related

How To Increase Value To Larger And Not Lower

Nov 26, 2012

I have 83,33 value. If I like to increase into 84 and not 83 without decimal point

View 11 Replies View Related

Return Set Value If Cell Is Lower

May 11, 2012

I am trying to get a simple formula to look in A1 and if it is lower than A2 then return the value in A1 if it is not then return the value in A2..

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved