Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"little bear" wrote in message
...
thank you very much. that is a perfect solution that i can actually
understand.

"Ragdyer" wrote:

Assume your datalist is in A1 to B1000.

Say you enter 7/1/06 at the top of a column, say D1.
Then drag it down to increment it and make a list of individual days,
like:
7/1/06
7/2/06
7/3/06
.... etc.

Drag down as far as necessary.

Then in E1, enter this *array* formula:

=AVERAGE(IF(A$1:A$1000=D1,B$1:B$1000))

--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead
of
the regular <Enter, which will *automatically* enclose the formula in
curly
brackets, which *cannot* be done manually. Also, you must use CSE when
revising the formula.

*After* the CSE, drag the formula down to copy as needed,
OR
*Double Click* on the fill handle of E1, to *automatically* copy the
formula
down Column E, as far as you have entered your date list in Column D.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"little bear" wrote in message
...
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!