Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Slope??? help please!!!
------ I have 4 columns : <---------
COLUMN A: Dates (ex. 1/15/2009) COLUMN B: Time (ex. 1:35:24 AM) COLUMN C: Dates and Time added and shown in the format dd/mm/yyyy hh/mm " and converted to a number gives: (ex. 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 that automatically takes the values that correspond from the date 1/16/2009 to 1/18/2009 and give me the slopes from the values located on "COLUMN D (Y-axis )" and " COLUMN C (X- axis )" from the desire range of dates. I Tried the following: --------- worksheet "2" <----------- Cell A1: 1/16/2009 Cell A2: 1/18/2009 Using as range A1 to A2 (1/16/2009, 1/17/2009, 1/18/2009) Cell B2 : =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 functions, but to be honest I do not know how to do it. Thanks! I hope someone can help..... ???????? -- asdf |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
slope? | Excel Worksheet Functions | |||
How to get slope | Excel Discussion (Misc queries) | |||
Slope | Excel Discussion (Misc queries) | |||
Slope | Excel Discussion (Misc queries) | |||
Slope using dates | Excel Discussion (Misc queries) |