Is there a way to use non contiguous cells with the slope function?
Specifically, if y's and x's contain non contiguous values.
SLOPE(known_y's,known_x's)
A simple example...
x's y's
1 10
2 12
3 30
4 32
5 60
6 68
Where...
desired x's = 1, 3, 5
desired y's = 10, 30, 60
Thanks,
-Zack
Jim Thomlinson - 28 May 2008 19:51 GMT
Nope... The ranges must be contiguious...

Signature
HTH...
Jim Thomlinson
> Is there a way to use non contiguous cells with the slope function?
> Specifically, if y's and x's contain non contiguous values.
[quoted text clipped - 18 lines]
>
> -Zack