Hi,
Within a post logging spreadsheet, the date of logging is automatically
entered against each entry on the day the data is input and formatted thus:
'21-Jun' . I wish to find out the daily min, daily max and daily average of
the entries over the year and, if poss to adapt the formula to reflect the
weekly min, max and ave over the same period.
Any help appreciated.

tia

Jock

Sounds like a job for a pivot table

http://www.cpearson.com/excel/pivots.htm

http://edferrero.m6.net/Pivot.html

http://it.fuqua.duke.edu/public/2001...troduction.pdf

http://peltiertech.com/Excel/Pivots/pivotstart.htm

http://www.contextures.com/xlPivot01.html


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jock" <(E-Mail Removed)> wrote in message
news:E21C8592-7BE4-42C0-AC95-(E-Mail Removed)...
> Hi,
> Within a post logging spreadsheet, the date of logging is automatically
> entered against each entry on the day the data is input and formatted
> thus:
> '21-Jun' . I wish to find out the daily min, daily max and daily average
> of
> the entries over the year and, if poss to adapt the formula to reflect the
> weekly min, max and ave over the same period.
> Any help appreciated.
>
> tia
>
> Jock

1. First create a Pivot Table giving the count of items by date. This will
produce a table about 365 entries long, one entry for each day of the year.

2. Then you can use simple MIN, MAX, and AVERAGE to get the desired values.

3. Then you can use MATCH and INDEX to get the dates on which the values
ocurred
--
Gary''s Student - gsnu200731


"Jock" wrote:

> Hi,
> Within a post logging spreadsheet, the date of logging is automatically
> entered against each entry on the day the data is input and formatted thus:
> '21-Jun' . I wish to find out the daily min, daily max and daily average of
> the entries over the year and, if poss to adapt the formula to reflect the
> weekly min, max and ave over the same period.
> Any help appreciated.
>
> tia
>
> Jock

Thanks to both Gary & Bob
--
tia

Jock


"Bob Phillips" wrote:

> Sounds like a job for a pivot table
>
> http://www.cpearson.com/excel/pivots.htm
>
> http://edferrero.m6.net/Pivot.html
>
> http://it.fuqua.duke.edu/public/2001...troduction.pdf
>
> http://peltiertech.com/Excel/Pivots/pivotstart.htm
>
> http://www.contextures.com/xlPivot01.html
>
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "Jock" <(E-Mail Removed)> wrote in message
> news:E21C8592-7BE4-42C0-AC95-(E-Mail Removed)...
> > Hi,
> > Within a post logging spreadsheet, the date of logging is automatically
> > entered against each entry on the day the data is input and formatted
> > thus:
> > '21-Jun' . I wish to find out the daily min, daily max and daily average
> > of
> > the entries over the year and, if poss to adapt the formula to reflect the
> > weekly min, max and ave over the same period.
> > Any help appreciated.
> >
> > tia
> >
> > Jock
>
>
>

thanks for the references
--
Gary''s Student - gsnu200731