average for new date
A not very sophisticated solution but here goes:
Assuming data is sorted by date and starts in row 2:
In C2 (say):
=IF(A2<A1,SUMIF($A$2:$A$9,A2,$B$2:$B$9)/COUNTIF($A$2:$A$9,A2),"")
Change ranges and copy down.
It will calculate average and put in column C against first occurence of a
given date. You can copy/paste special, filter (on "not blank" )to get list
with dates.
HTH
"little bear" wrote:
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!
|