Re: Is it possible to use Excel's SLOPE function on a non-continuous r

[Tushar Mehta]

No, I believe you have to have data in a contiguous range. Of course,
you could always create a secondary area, say A3:C3 that is contiguous
with formulas like =A1, =C1, and =E1

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <54932059-839C-4D10...@microsoft.com>, "=?
Utf-8?B?amVzc2UgamFtZXM=?=" <jesse ja...@discussions.microsoft.com>
says...
> Is it possible to use Excel's SLOPE function on a non-continuous range?
>
> Slope works fine if you have data in A1:C1 that you want to compare to A2:C2 ( =SLOPE(A1:C1,A2:C2) ). However, as soon as you want to compare A1, C1 & E1 to A2:C2, Excel will not accept the formula.
>
> Has anyone found a workaround for this?
>
> Thank you in advance.
>
> -Jessy Houle
>

[excel question guy 77]

INDIRECT worked!!! Thank you.

"hgrove >" wrote:

> jesse james wrote...
> ...

> >Slope works fine if you have data in A1:C1 that you want to
> >compare to A2:C2 ( =SLOPE(A1:C1,A2:C2) ). However, as soon
> >as you want to compare A1, C1 & E1 to A2:C2, Excel will not
> >accept the formula.

> ...
>
> The general approach to converting multiple area ranges into a single
> array involves either INDIRECT or OFFSET.
>
> =SLOPE(N(INDIRECT({"A1","C1","E1"})),A2:C2)
>
> =SLOPE(N(OFFSET(A1,0,{0,2,4},1,1)),A2:C2)
>
> The N() calls are *NOT* optional. INDIRECT and OFFSET when fed array
> first arguments return what appear to be arrays of range references. If
> you enter their results into multiple cell ranges, Excel displays the
> values in those ranges. However, you can't use their results directly
> as intermediate array values in other expressions. Wrapping them insice
> N() converts the array of range references to an array of the numeric
> values of the top-left cell in each of the range references.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>
>