Perhaps one way ..
Try in B3:
=PEARSON(OFFSET(Ranks!$A$3:$A$10,,ROWS($A$1:A1)),R anks!B$3:B$10)
Copy B3 across to DT3, fill down
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Zeelotes" wrote in message
...
Just take out the $ sign before the row numbers.

Rgds

------------------------------

Doing this will cause the results to not match the succeeding columns. Let
me illustrate:

C4 must be: =PEARSON(Ranks!$C$3:$C$230,Ranks!C$3:C$230)

D5 must be: =PEARSON(Ranks!$D$3:$D$230,Ranks!D$3:D$230)

E6 must be: =PEARSON(Ranks!$E$3:$B$230,Ranks!E$3:B$230)

In other words, each successive row must be fixed in the first part to the
next column over.

I'm guessing you have to use COLUMN or INDEX or OFFSET or some similar
function which I am not familiar with.

Thanks for the offer of help.