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" wrote in message
...
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