On Mon, 17 Oct 2005 14:21:47 +0800, "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.

Just take out the $ sign before the row numbers.

Rgds



__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________