Morring Matrix with Google Drive SpreadSheets

791 views Asked by At

I'm trying to mirror a matrix over a diagonal, but i don't know how. Is there a way of getting the cell in some position of a selection of the type C5:P5 ?

enter image description here

I'm looking for a function for each column or row of the inferior part of the matrix.

1

There are 1 answers

7
Scott Craner On BEST ANSWER

Use this formula in the first cell B4:

=OFFSET(B4,-1*(ROW(1:1)-COLUMN(A:A)+1),ROW(1:1)-COLUMN(A:A)+1,1,1)

Change the B4 to the cell address into which cell you placed the formula.

Then copy and paste the cell into all the desired cells.

enter image description here

It works in Google as well:

enter image description here