Hi,

Not sure I understand your answer... let's see, what I'm asking is if
it is possible to convert this to an array formula:

c1:
=MAX(pearson(a1:a5,a2:a6),pearson(a1:a5,a3:a7),... ..,pearson(a1:a5,an:an
+4))

so, you see, I don't want to type all the (....) terms in between (I
can't actually)

hope is clearer now..

Thanks
Mika