Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: min max by date

  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 water level data for every 10 or 15 minutes per day. And I'd like to find the min/max range per day and take an average (for roughly 5 months of data collection.) The problem is that there are times when the datalogger did not take readings, so that there isn't a consistent number of readings per day.

    Much appreciated!
    Isa

  2. #2
    Board Regular zacemmel's Avatar
    Join Date
    Apr 2002
    Location
    Redmond, WA
    Posts
    636
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    When the logger didn't get a "reading," is that cell left blank or is there a zero in it's place?

    Also, why don't you just use =max(range) The min portion will depend on how the "non readings" are returned.

    [ This Message was edited by: zacemmel on 2002-05-07 09:43 ]

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

    Default

    Thanks for the reply, but being the novice I am, I don't know how to set the range to automatically advance for each day. The missing readings from the datalogger are deleted.

    ...I tried using subtotals by date and I tried to copy the max and min values only; but I ended up copying all values. I couldn't figure out how to copy only the min/max values.

    Thank you much.

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,063
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    On 2002-05-07 10:09, blueberry wrote:
    Thanks for the reply, but being the novice I am, I don't know how to set the range to automatically advance for each day. The missing readings from the datalogger are deleted.

    ...I tried using subtotals by date and I tried to copy the max and min values only; but I ended up copying all values. I couldn't figure out how to copy only the min/max values.

    Thank you much.
    I suspect that you have lots of data. You could create daily descriptive stats like min. max, range, average in a separate worksheet. This requires knowledge of the layout of the worksheet containing the data.

    Care to describe that layout and provide a small sample of your data?

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

    Default

    The data I have is pretty simple, but you're right, there's a lot of values. I have water level data of a tidal marsh that experiences 2 high tides and 2 low tides per day, with one of the tides being higher and lower than the other. So, there's a low high tide, high high tide, low low tide and high low tide.

    I'm interested in the extreme highs and lows per day and the data is set up with 3 columns. the first column is the date, column 2 is the time, and column 3 is the level of the water. And since the data's pretty extensive (we have a couple years of data every 10 or 15 minutes), I was hoping to figure out how to automate the extreme tide levels for each day and to average them over a lunar cycle. I'm not sure how to set up the min/max equation with a range that will automatically calculate the next day's and the next day's min/max and then average them by month. ...help!

  6. #6
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-07 15:46, blueberry wrote:
    The data I have is pretty simple, but you're right, there's a lot of values. I have water level data of a tidal marsh that experiences 2 high tides and 2 low tides per day, with one of the tides being higher and lower than the other. So, there's a low high tide, high high tide, low low tide and high low tide.

    I'm interested in the extreme highs and lows per day and the data is set up with 3 columns. the first column is the date, column 2 is the time, and column 3 is the level of the water. And since the data's pretty extensive (we have a couple years of data every 10 or 15 minutes), I was hoping to figure out how to automate the extreme tide levels for each day and to average them over a lunar cycle. I'm not sure how to set up the min/max equation with a range that will automatically calculate the next day's and the next day's min/max and then average them by month. ...help!
    You can use functions like DMAX, DMIN, ... etc with the associated criteria of interest.

    Regards!

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
  •