delete upper triangular matrix ???

S

Sam

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
 
A

Alan Beban

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

triangular correlation matrix 2
Have data to fill a triangular matrix, but how do I graph it???? - Please help 10
Correlation matrix 7
SUM - IF - AND 7
filter a matrix 4
Matrix manipulation in vba code 2
Constructing Inner and Outer Loops in Excel VBA 2
UDF function on Matrix 1

Top