Prev: Summing weekly values to fall into correct month
Next: HOW TO USE BAHTTEXT FORMULA
From: Roger Hn Roger on 28 Jan 2010 00:07
Is there a function in MS Office 2007 Excel that will 'invert a matrix'?
That is, I want my columns to become rows and rows to become columns in the
new matrix.
From: Jacob Skaria on 28 Jan 2010 00:25
Copy the range. Select a cell. Right click>Paste Special>check 'Transpose'
and select 'Values' and hit OK

--
Jacob


"Roger Hn" wrote:

> Is there a function in MS Office 2007 Excel that will 'invert a matrix'?
> That is, I want my columns to become rows and rows to become columns in the
> new matrix.
From: Dave Peterson on 28 Jan 2010 08:44
There's also the worksheet function =transpose().

Look at excel's help for more info.

Roger Hn wrote:
>
> Is there a function in MS Office 2007 Excel that will 'invert a matrix'?
> That is, I want my columns to become rows and rows to become columns in the
> new matrix.

--

Dave Peterson
 | 
Pages: 1
Prev: Summing weekly values to fall into correct month
Next: HOW TO USE BAHTTEXT FORMULA