Correlation matrix between series of different lengths

Use the =correl() function after all errors have been handled. I exchanged all errors with zeros by using the =iferror()

Thanks for your insight but I'm afraid this solution is erroneous.

The new zeros will be taken into account for the calculation of the correlation when really they should. In the file you sent back to me we can see that the correlation between series 1 and 2 with your method is 0.4 when the true correlation (array 1 being B4:153 and array 2 being C4:C153) is 0.64. Quite the difference !

Thanks for the effort however! :D

Try exchanging the 0 in the =iferror() to "". This seems to work.

Oh yeah that simple fix does seem to work! Fantastic! You just saved me over 1 hour of tedious work