Hello,
The following formula yielded a correlation of only 20% and my gut tells me it should be significantly higher:
=CORREL(AX37:AZ37,AX44:AZ44)+CORREL(AN37:AO37,AN44:AO44)+CORREL(Z37:AK37,Z44:AK44)
I can't relocate the cells so that all arrays are adjacent so that is not an option.
Thank you,
Patrick
Bookmarks