Hi,

I have Residual output for Regression from SAS in CSV format.

I have to make a scatter plot between Residual and the Predicted
variable. Problem is that my original data set in SAS has close to 0.2
million rows, so I have 0.2 million rows of residual information.

I can open this data in Textpad and paste to excel 65536 rows at a
time.

So, in first copy-paste my dependent variable and residual would be
lets say in Columns E and F. In next copy-paste I can paste these 2
columns in K and L and subsequently in Q, R and then fianlly in W and
X.

I am aware of named functions in excel which can be used within charts
etc. what I want o know is whether I can create a named formula which
will be union of the ranges given above. (Am aware of the union
function within VBA, but do we have equivalent Non-VBA formula based
solution for this?).

Please guide me.

regards,
Hari
India

PS : Please note am not using excel for data management and the above
requirement is just for one-time "appraisal" of a model.