#1
|
|||
|
|||
dynamic ranges to calculate average
i have a time series in which a varying amound of values are recorded per day. I would like to compute the average per day.
here is the dataset for reference: http://harvardforest.fas.harvard.edu....html?id=hf006 , sheet name: hf006-03: autochamber I have tried to work with if-statements to define when one day stops and the next ends, but I would have to make a second one to define the range and now I am stuck. I have not found any other good solution in forums, please help. Thanks! |
#2
|
||||
|
||||
Duplicate thread - Thread closed
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
dynamic ranges, time series |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculate average age | FTL | Excel | 1 | 08-09-2016 06:56 AM |
Dynamic chart ranges | GlowingApple | Excel | 1 | 02-17-2016 07:18 PM |
Calculate Average Time Elapsed in Days, hours and minutes | Nina46 | Excel | 9 | 09-11-2015 02:09 AM |
calculate average depending on drop-down values | virencm | Word | 0 | 08-06-2010 06:10 PM |
Dynamic Named Ranges using text | hannu | Excel | 0 | 06-22-2010 04:42 PM |