Perhaps you need to explain more clearly what you are trying to do.
In which cell do you have your original =CORREL($B$2:$B$253,B$2:B$253)
formula?
What do you want to do to that when you go across one column?
What do you want to do to the original formula when you go down one row?
OFFSET may be the right answer, but if you explain what you're looking for
we can probably help.
--
David Biddulph

"Number_Cruncher" wrote in message
ups.com...
I suggest that you look at Excel help for absolute and relative
addressing,
so that you understand the meaning of the $ signs in your formula.
-
David Biddulph

The formula that I've written works perfectly to copy from column B
over to column CX or however far the matrix goes. The problem is that
I need a way so that I do not have to change the B to C to D, etc,
when I move down one row. I'm trying to use this formula but am not
getting it right:

=CORREL(OFFSET($B$2,0,SUM(ROW()-CELL("Row",$B$253)),$A$264),OFFSET($B
$2,0,SUM(COLUMN()-CELL("Col",$B$253)),$A$264))

As to reading the help file --- I did that first, and when that
failed, I came looking for help. I certainly appreciate the fact that
for those with more expeience this is easy to do.