Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
How do I summarize a large data set based on specifiec parameters. For
example, I have a data set of water level measurements recorded at 1 hour increments for 1 year. I would like to calculated a daily average water level for each day. Is there a faster way to do this than manually selected all of the recordings within each day and individually calculating daily means. In other words, is there a formula I can use that tells excel to calculated means for each day? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy/print specific data | Excel Worksheet Functions | |||
specific data selection/pasting | Excel Discussion (Misc queries) | |||
populating sheets based on data from parent sheets | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |