Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: automatic averaging

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've got thousands of water level readings I'd like to average based on varying time periods. Is there a way that I can average the data automatically for, let's say, 1 week for the entire dataset. Can someone tell me if I can also get a max and min?

    Much appreciated!

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could use a Pivot Table and group by date. You can select average (or Min, Max)for the Data Field option. Your data will have to be arranged in a table format with one column for dates, the other for readings. Then create the Pivot Table. Use Dates for the row field, Readings for the Data Field. You can group the date field by weeks, months, quarters, etc.

  3. #3
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi blueberry


    A pivot Table would also be my first choice, but also look under Data>Subtotals



Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •