ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   delete upper triangular matrix ??? (https://www.excelbanter.com/excel-programming/273297-delete-upper-triangular-matrix.html)

Sam

delete upper triangular matrix ???
 
hi there

i have a 100 by 100 symmetric correlation matrix.
i want to hide or automatically delete the values in the upper
triangular matrix and only show the lower triangular matrix.

i dont want to manually delete this data.
can an if statement or a mcro do this ?


sam

Alan Beban[_3_]

delete upper triangular matrix ???
 
Is the diagonal in the upper or lower triangular matrix? Does the upper
triangular matrix include the element at (2,1), or (2,100)?

Alan Beban

Sam wrote:
hi there

i have a 100 by 100 symmetric correlation matrix.
i want to hide or automatically delete the values in the upper
triangular matrix and only show the lower triangular matrix.

i dont want to manually delete this data.
can an if statement or a mcro do this ?


sam




All times are GMT +1. The time now is 12:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com