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