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.