Bernie, thanks for your reply and help.

However I don't quite understand. How can I select contiguous blocks that
aren't "close to each other"? What do you mean by that statement?

"Bernie Deitrick" wrote:

No. The two arguments for each function must be contiguous blocks of cells, though the two blocks
don't need to be near each other.

--
HTH,
Bernie
MS Excel MVP


"BGKeen629" wrote in message
...
Can I use the functions of "slope" and "intercept" to select non-contiguous
sets of values?