Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default "Slope" and "intercept" function help

Can I use the functions of "slope" and "intercept" to select non-contiguous
sets of values?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,441
Default "Slope" and "intercept" function help

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?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default "Slope" and "intercept" function help

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?




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 762
Default "Slope" and "intercept" function help

BGKeen629 -

For example, the Xrange could be A1:A10 and the associated Yrange could be
C21:C30.

- Mike
http://www.mikemiddleton.com

"BGKeen629" wrote in message
...
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?






  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 733
Default "Slope" and "intercept" function help

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.

....

The arguments could be arrays, and arrays can be constructed from
nonadjacent cells.

Brute force:

A2*{1;0;0;0;0;0;0;0;0;0;0;0}+B4*{0;1;0;0;0;0;0;0;0 ;0;0;0}+C6*{0;0;1;0;0;0;0;0;0;0;0;0}
+D8*{0;0;0;1;0;0;0;0;0;0;0;0}+E10*{0;0;0;0;1;0;0;0 ;0;0;0;0}+F12*{0;0;0;0;0;1;0;0;0;0;0;0}
+G14*{0;0;0;0;0;0;1;0;0;0;0;0}+H16*{0;0;0;0;0;0;0; 1;0;0;0;0}+I18*{0;0;0;0;0;0;0;0;1;0;0;0}
+J20*{0;0;0;0;0;0;0;0;0;1;0;0}+K22*{0;0;0;0;0;0;0; 0;0;0;1;0}+L24*{0;0;0;0;0;0;0;0;0;0;0;1}

Same more compactly using the name seq defined as
={1;2;3;4;5;6;7;8;9;10;11;12}

A2*(seq=1)+B4*(seq=2)+C6*(seq=3)+D8*(seq=4)+E10*(s eq=5)+F12*(seq=6)
+G14*(seq=7)+H16*(seq=8)+I18*(seq=9)+J20*(seq=10)+ K22*(seq=11)+L24*(seq=12)

Same more compactly still but using the volatile OFFSET function

N(OFFSET(A2,2*(ROW(A1:A12)-1),ROW(A1:A12)-1,1,1))

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"