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 ?
I'm looking for a function for each column or row of the inferior part of the matrix.
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 ?
I'm looking for a function for each column or row of the inferior part of the matrix.
Use this formula in the first cell B4:
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.
It works in Google as well: