Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
average for new date
I have a table of dates and values with a different number of rows for each
date, and i would like to average over each date no matter how many rows there are for each date. the data look like: 7/1/06 1 7/1/06 2 7/1/06 3 7/2/06 5 7/2/06 3 7/3/06 9 7/4/06 1 7/4/06 2 so what i need to do is increment the date and calc the average of all the corresponding values for that date, then go to the next date, etc. there are 26,000 rows of data. Thank you very much! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count between start date and end date | Excel Discussion (Misc queries) | |||
Determining Date X based on Other dates | Excel Worksheet Functions | |||
Calculate difference between 2 date and times with average | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions | |||
Average to date | Excel Worksheet Functions |