Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Averaging Values between Two Dates/Times
Hi All,
I have a spreadsheet that contains 4 columns. Column A = start date, Column B = Start Time, Column C = Stop Date, Column D = Stop Time. I have another spreadsheet which contains meteorological data for a given time period. The data in this spreadsheet lists the Date in column A1 through A(n) (eg. Jan 1, 2005 to March 1, 2005). Columns C through AB list the time (0:00 to 23:00) corresponding to the date from column A. So the data looks like a large matrix with dates listed in the rows of column A and 24 hour times listed in columns C to AB. Basically, I am looking for a function in Excel or a program in VBA to read the start date and time and the stop date and time from the first spreadsheet and then average the meteorological values that correspond to that day/time interval on the second spreadsheet. Is this possible or not??? Any help would be greatly appreciated as I am very lost. Thanks Chris |
#2
|
|||
|
|||
Averaging Values between Two Dates/Times
You have a response in public.excel
-- HTH RP (remove nothere from the email address if mailing direct) "ChrisM" wrote in message ... Hi All, I have a spreadsheet that contains 4 columns. Column A = start date, Column B = Start Time, Column C = Stop Date, Column D = Stop Time. I have another spreadsheet which contains meteorological data for a given time period. The data in this spreadsheet lists the Date in column A1 through A(n) (eg. Jan 1, 2005 to March 1, 2005). Columns C through AB list the time (0:00 to 23:00) corresponding to the date from column A. So the data looks like a large matrix with dates listed in the rows of column A and 24 hour times listed in columns C to AB. Basically, I am looking for a function in Excel or a program in VBA to read the start date and time and the stop date and time from the first spreadsheet and then average the meteorological values that correspond to that day/time interval on the second spreadsheet. Is this possible or not??? Any help would be greatly appreciated as I am very lost. Thanks Chris |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Averaging Values between Two Dates/Times
As well as multiple posts in New Users, a few in programming.....
"Bob Phillips" wrote: You have a response in public.excel -- HTH RP (remove nothere from the email address if mailing direct) "ChrisM" wrote in message ... Hi All, I have a spreadsheet that contains 4 columns. Column A = start date, Column B = Start Time, Column C = Stop Date, Column D = Stop Time. I have another spreadsheet which contains meteorological data for a given time period. The data in this spreadsheet lists the Date in column A1 through A(n) (eg. Jan 1, 2005 to March 1, 2005). Columns C through AB list the time (0:00 to 23:00) corresponding to the date from column A. So the data looks like a large matrix with dates listed in the rows of column A and 24 hour times listed in columns C to AB. Basically, I am looking for a function in Excel or a program in VBA to read the start date and time and the stop date and time from the first spreadsheet and then average the meteorological values that correspond to that day/time interval on the second spreadsheet. Is this possible or not??? Any help would be greatly appreciated as I am very lost. Thanks Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
Averaging Values in Auto Filter | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Averaging selected values | Excel Worksheet Functions |