It appears that you already have a solution, so my contribution is
simply to point out that if you are using an Excel version prior to
2003, then you should be using CORREL() instead of PEARSON().

CORREL() and PEARSON() are mathematically equivalent, but in versions
prior to 2003, PEARSON() uses a numerically inferior algorithm.

Jerry

Zeelotes wrote:

I'm trying to Pearson Ranks correlation table. This is the formula I'm
using:

=PEARSON(Ranks!$B$3:$B$230,Ranks!B$3:B$230)

This is placed in cell B3. When I copy the formula over to DT3 the formula
correctly adjusts the B in the second part of the formula all the way to DT
and still references the values in the B column.

But I want to now copy this down to C4, D5, E6 and then over to DT for each
so that it correctly makes the correlation table.

What is the best way to do this?

Thanks for any help you can provide.