Hi,

my problem is the following:

I often copy and paste correlation matrices from a statistical software (SPSS) into excel. I am looking for an easy way to select only the cells below or above the diagonal. Let me illustrate:

A B C
1 1.0 0.2 0.3
2 0.2 1.0 0.4
3 0.3 0.4 1.0

I would like to select cells A1,A2,B2,A3,B3,C2, just like if I held down control and clicked each cell with the mouse.

Ideally, I want to write a macro that will do this when i select a range of quadratic dimension. Maybe this is also possible by selecting only the first and last cell.

There is one more problem: Sometimes, the matrices are spread out so that there are two blank rows between each row that I want to select: (i.e., the p values and sample sizes that SPSS prints and that I want to ignore).

e.g.:

A B C
1 1.0 0.2 0.3
2
3
4 0.2 1.0 0.4
5
6
7 0.3 0.4 1.0
8
9

Can anyone help? I'd really appreciate it!

as