Hi all,
I guess you gonna resolved this newbie issue in few lines...
I have a dataset of 4320 rows for 17 columns.
Each row is a minute. I want to average my data per hour.
If I do Average formula which encompass 60 rows, for the first hour it works. But then if I drag the formula down one row it will give me the average of the data +1min, not +60min
How can I adapt any formula to jump over 60rows each time I drag the formula down one row.
Thank a lot, it gonna be more than helpful
Raph
ps: I add an excel with one of the column and the corresponding averaging I need
Bookmarks