Number_Cruncher -

As an aside, since you're replicating the results of the Correlation tool in
Excel's Analysis ToolPak, I checked in Excel 2007 to see if it could handle
"over 300 of them," just in case you were referring to the number of
variables instead of the number of values for each variable. I can report
that the Correlation tool of the Excel 2007 Analysis ToolPak will produce
pairwise correlations for 301 variables.

- Mike
http://www.mikemiddleton.com


"Number_Cruncher" wrote in message
oups.com...
I'm tring to set up a correlation matrix where a table contains the
same headings in both the x and y axis. I then use this formula to
find the correlation:

=CORREL($B$2:$B$253,B$2:B$253)

This returns 1 since it is the correlation of itself. The next column
over produces this formula:

=CORREL($B$2:$B$253,C$2:C$253)

What is the best way to write a formula that does not require me to
manually switch the B to a C for each and every row --- over 300 of
them.

=CORREL($C$2:$C$253,C$2:C$253)

Thanks for any help you can offer.