LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 24
Default Slope using dates

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





 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
slope of data that already contains STDEVs Adriank Excel Discussion (Misc queries) 1 December 9th 08 05:14 AM
=SLOPE(OFFSET(INDEX .... Help please Mark K[_2_] Excel Worksheet Functions 9 July 11th 08 01:49 PM
Hot to calculate montly slope? Roy Excel Worksheet Functions 2 March 17th 08 09:47 AM
SLOPE, (error in b if y= a+ bx) Miesjz Excel Worksheet Functions 1 March 10th 08 12:13 PM
Slope of graph? LJ555555 Charts and Charting in Excel 3 September 27th 05 02:59 PM


All times are GMT +1. The time now is 08:14 AM.

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"