How to summarize data based on specific parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Assume the data starts in A2 going down

=AVERAGE(OFFSET($A$2,ROW(1:1)*24-24,,24,))

if you copy it down it will average A2:A25, A26:A49 and so on,
so copy it down 365 rows and that should be it

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create sorted list based on cell values 7
How do I create unique pivot tables from the same data 1
Creating an update query that uses multiple parameters 2
Pivot Table Summarizing Quirk - Please Help 1
How do I summarize unusual column data? 4
Data Selection 4
Multiple Pivot Tables based on the same data 3
Patient Demand on X Day of the Month 4

Back
Top