Correlation based on cell's value

[technomau]

Hello All,

I am trying to create a correlation matrix in tab "Correlation" based on cell value C2 (years). However, I am getting DIV/0 with the formula I am applying.
Can you please advise?

Thanks!

 

[vletm]

technomau
Your previous thread had an option - where You named wanted date range.
I gave a formula base full data range.

 

[bosco_yip]

Guessing,

In B20, formula copied across and down :

=IFERROR(CORREL(OFFSET('Assets RawData'!$B$1,MATCH($C$2,'Assets RawData'!$B$3:$B$266,0)+1,ROWS($A$1:$A1)+COLUMNS($A$1:A$1)-1,COUNTIF('Assets RawData'!$B$3:$B$266,$C$2)),OFFSET('Assets RawData'!$AC$1,MATCH($C$2,'Assets RawData'!$B$3:$B$266,0)+1,ROWS($A$1:$A13)+COLUMNS($A$1:A$1)-1,COUNTIF('Assets RawData'!$B$3:$B$266,$C$2))),0)