Using Concatenate with Correl in excel

[torealden]

I am building a correlation matrix and I want to be able to vary the starting and ending cells in the arrays I am using to calculate the correlations. So far each time I change I have had to retype the formula in each of the 210 boxes in my matrix. I would like to be able to use concatenate in the correl function so I can just change a couple of reference cells and produce new results in the correlation matrix. Is there any way to do this other than changing the formula in each of the cells? Thanks for your help.

 

[Robert Mika]

I am building a correlation matrix and I want to be able to vary the starting and ending cells in the arrays I am using to calculate the correlations. So far each time I change I have had to retype the formula in each of the 210 boxes in my matrix. I would like to be able to use concatenate in the correl function so I can just change a couple of reference cells and produce new results in the correlation matrix. Is there any way to do this other than changing the formula in each of the cells? Thanks for your help.

Hello and welcome to MrExcel.
There are few ways of changing references(INDIRECT woudl be one).
Could you post sample of your data+formula you are using+desired result