Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting date entries which are the same
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting date entries which are the same
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting date entries which are the same
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting date entries which are the same
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" 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting date entries which are the same
thanks for the references
-- Gary''s Student - gsnu200731 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting entries | Excel Worksheet Functions | |||
Counting the number of date entries in a giving month | Excel Discussion (Misc queries) | |||
counting date entries by month & year | Excel Worksheet Functions | |||
Counting Entries | Excel Worksheet Functions | |||
counting specified date entries | Excel Worksheet Functions |