View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_3_] Alan Beban[_3_] is offline
external usenet poster
 
Posts: 130
Default 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