hard slope question


B

beto

let see if you can answer me this question.....

I have 4 columns
COLUMN A: Dates (1/15/2009)
COLUMN B: Time (1:35:24 AM)
COLUMN C: Dates combined with time as format " dd/mm/yyyy hh/mm " and shown
as number: ( 40035.01 ) this would be the "X-axis data"
COLUMN D: " Y-Axis Data "

Excell sheet "1"
A B C D
1/15/2009 1:35:24 AM 40035.01 1234
1/15/2009 2:15:20 AM 40035.11 2345
1/15/2009 3:24:31 AM 40035.26 2456
1/16/2009 1:15:20 AM 40036.01 3456
1/16/2009 7:30:23 AM 40036.13 4567
1/17/2009 9:24:23 AM 40037.19 5678
1/18/2009 3:35:23 AM 40038.25 6789
1/19/2009 3:37:23 AM 40039.25 6789

Excel sheet "2"

I want to create an array to automatically takes the values that correspond
from the date 1/16/2009 to 1/18/2009

therefore, get the slope from a linear trend-line using the number from
sheet "1" .
Using as a " Y-axis the COLUMN D" and "X- axis the COLUMN C" from the desire
dates.
 
Ad

Advertisements

Ad

Advertisements

B

beto

Well, that is not going to work with what I want, but thanks any way.

What I want is something like this, a little bit more complicated:
let say I have :

worksheet "2"
Cell A1: 1/16/2009
Cell A2: 1/18/2009

So I want to go to sheet "1" (where the data is located) and get the slope
from the range A1 to A2 (1/16/2009, 1/17/2009, 1/18/2009)

=Slope(IF(ISNUMBER(MATCH(1!$C$5:$C$45000,2!A1:A2,0)),1!$d$5:$d$45000))

That function is the one I am trying to use but it doesn't work, maybe the
slope can not be combined with other funtions, but to be honest I do not know
how to do it.

Maybe know you can see what my question is........

Thanks! I hope someone can help..... ????????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top