I have a spreadsheet with over 45,000 lines of information. It is data that was collected every minute for a month.
Column A has the time in hh:mm:ss form, and column B has the data in standard number form.
Now I need to average the data by 1 hour, 3 hour and 24 hour spans. Is there an easy way to do this with a function, such as =AVERAGEIF?
Show us an example of your excel file, without confidentional information.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks