Using CORREL with arrays containing null values
XL Gurus...
I'm using the CORREL function, but one of the arrays I'm comparing has null
values (entered as #N/A), so my result is #N/A. How can I modify my formula
to correlate all the points in the 2 arrays, apart from the null values and
their corresponding entries in the other array?
|