Re: Correlation Tables -- Setup

Slightly puzzled. Is there a typo above? -- Yes, a typo to the right of E6.

The solution to your query no doubt lies with the INDIRECT function
but I'm not yet quite understanding your query. -- I'm sure willing to
learn how if you can explain. Max's solution works perfectly, but if there
is another way I'm sure I'll learn even more from this.

Secondary question, doesn't the Rank correlation require two different
data sets, one dependent on the other? If so why are both sets the
same in your example? -- the result of the formula I give is 100% or just
one depending on the formatting. But as the formula is copied over to the
right, the values will reflect the Spearman rank for each of the distinct
trading strategies being compared to the one that is locked. Make sense?


.