I am attempting to use the column() function to identify ranges inside the
correl function and get #N/A in the results. The formula is
=CORREL(OFFSET(A1,87,COLUMN(),3,1),B87:B90).

When it show the calculation steps, the evaluation for the column function
show {} around the result and the offset function evaluates as #VALUE!. I
can't figure out what the {} are supposed to represent. The column function
is calculated correctly but doesn't seem to get used in the offset function.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc