| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
Using CORREL with arrays containing null values
You might incorporate an IF function, along the lines of
IF(ISNUMBER(your array function here),your array function here,0) It seems redundant, but it evaluates the array function to determine if it is numeric. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cntrl + down arrow and null values in cells | Excel Discussion (Misc queries) | |||
| Displaying null values in charts | Charts and Charting in Excel | |||
| Multipying columns that contail null values | Excel Discussion (Misc queries) | |||
| Problem with plotting a chart when using arrays as Values and Xvalues | Charts and Charting in Excel | |||
| Can I "CORREL" statistical funtion with three or more Arrays? | Excel Worksheet Functions | |||
Linear Mode
