On Mon, 17 Oct 2005 19:13:52 +0800, "Zeelotes"
wrote:

Slightly puzzled. Is there a typo above? -- Yes, a typo to the right of E6.

With =PEARSON(Ranks!C$3:C$230,Ranks!C$3:C$230) in C3, this will copy
to say E6 as =PEARSON(Ranks!E$3:E$230,Ranks!E$3:E$230), which appears
to satisfy your original query - or am I still missing something?

Rgds



__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________