View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 21
Default 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