Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Slope" and "intercept" function help
Can I use the functions of "slope" and "intercept" to select non-contiguous
sets of values? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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 |
Display Modes | |
|
|