Greetings,

I am working with the SLOPE and RSQ functions. The x and y data span the same range, but some of the y data is missing. For the missing data I can either have blank cells or insert #N/A. The data charts fine with the missing data set to #N/A (it ignores NA xy pairs), but the SLOPE and RSQ formula I am using within the worksheet either counts the blank cells as zero (and returns the wrong value), or returns NA if the NAs are present instead. (Note that the missing data cells have lookups so the cells are not totally empty; the returned value for an error in the lookup is set to #N/A so the data charts correctly.)

So, my question: with straight cell functions or named ranges, how can I create two dynamic arrays as input to the SLOPE and RSQ functions, one for column A data and one for column B data (no blanks), that skips all rows containing #N/A in column B?

TIA!
WD