Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
triangular distribution | Excel Worksheet Functions | |||
triangular correlation matrix | Excel Discussion (Misc queries) | |||
Recreate the upper part of a symetric data matrix 75x75 | Excel Discussion (Misc queries) | |||
How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) | |||
Triangular Coordinates | Charts and Charting in Excel |