| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating daily average from multiple values per day
I've got a dataset with measurements at different time intervals per day.
Most are on the hour, so I could just create daily average for each 24 entries, but many have more (or less) per day. How do I create a daily average of each group of numbers per day? The data is formatted as column A=date, column B=amount |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average of multiple range with error values | Excel Worksheet Functions | |||
| Creating graph from values in multiple tabs within workbook | Charts and Charting in Excel | |||
| Calculate the average of numbers, ignoring multiple values | Excel Discussion (Misc queries) | |||
| Average Values / Multiple Worksheets | Excel Worksheet Functions | |||
| creating drop down lists where you can select multiple values | Excel Discussion (Misc queries) | |||
Threaded Mode
