Hi, I want to get the slope from Column C using a certain range of dates from
Column A. I did this already for getting the max value, but I do not how to
do it using Slope.

Example I did using Max:
=MAX(IF(ISNUMBER(MATCH($A$2:$A$500,M2:N2,0)),$c$2: $c$500))
M2=8/25/2009
N2=8/27/2009

"I need Slope"

ColumnA ColumnB ColumnC
8/24/2009 345 34
8/25/2009 345 465
8/25/2009 567 566
8/25/2009 456 465
8/26/2009 456 876
8/26/2009 244 243
8/26/2009 123 264
8/26/2009 876 436
8/27/2009 678 134
8/27/2009 484 134
8/27/2009 356 654
8/27/2009 456 456
8/27/2009 234 123
8/28/2009 567 453

You have several values in column C for 8/25/2009 and for 8/27/2009.
Do you want to take the average of these for each date, or the first,
or the last ???

Slope is the change in Y divided by the corresponding change in X, or
in your case:

(Cn - Cm) / (An - Am)

so if you can explain which values of C you want to take for those
dates then it's quite easy to plug them into this formula.

Hope this helps.

Pete

On Jan 25, 10:18*pm, beto wrote:
Hi, I want to get the slope from Column C using a certain range of dates from
Column A. I did this already for getting the max value, but I do not how to
do it using Slope.

Example I did using Max:
=MAX(IF(ISNUMBER(MATCH($A$2:$A$500,M2:N2,0)),$c$2: $c$500))
M2=8/25/2009
N2=8/27/2009

"I need Slope"

ColumnA * ColumnB *ColumnC
8/24/2009 * *345 * * * * * 34
8/25/2009 * *345 * * * * * 465
8/25/2009 * *567 * * * * * 566
8/25/2009 * *456 * * * * * 465
8/26/2009 * *456 * * * * * 876
8/26/2009 * *244 * * * * * 243
8/26/2009 * *123 * * * * * 264
8/26/2009 * *876 * * * * * 436
8/27/2009 * *678 * * * * * 134
8/27/2009 * *484 * * * * * 134
8/27/2009 * *356 * * * * * 654
8/27/2009 * *456 * * * * * 456
8/27/2009 * *234 * * * * * 123
8/28/2009 * *567 * * * * * 453

"Do you want to take the average of these for each date, or the first,
or the last ???"

Both options would help me a lot, taking the average for each date and then
do the slope.
Also taking the first and last.

Please if you can tell me how to do it I would appreciate it a lot.
Thanks!


--
asdf


"Pete_UK" wrote:

You have several values in column C for 8/25/2009 and for 8/27/2009.
Do you want to take the average of these for each date, or the first,
or the last ???

Slope is the change in Y divided by the corresponding change in X, or
in your case:

(Cn - Cm) / (An - Am)

so if you can explain which values of C you want to take for those
dates then it's quite easy to plug them into this formula.

Hope this helps.

Pete

On Jan 25, 10:18 pm, beto wrote:
Hi, I want to get the slope from Column C using a certain range of dates from
Column A. I did this already for getting the max value, but I do not how to
do it using Slope.

Example I did using Max:
=MAX(IF(ISNUMBER(MATCH($A$2:$A$500,M2:N2,0)),$c$2: $c$500))
M2=8/25/2009
N2=8/27/2009

"I need Slope"

ColumnA ColumnB ColumnC
8/24/2009 345 34
8/25/2009 345 465
8/25/2009 567 566
8/25/2009 456 465
8/26/2009 456 876
8/26/2009 244 243
8/26/2009 123 264
8/26/2009 876 436
8/27/2009 678 134
8/27/2009 484 134
8/27/2009 356 654
8/27/2009 456 456
8/27/2009 234 123
8/28/2009 567 453

.