+ Reply to Thread
Results 1 to 7 of 7

macro to return max value in a time-series

  1. #1
    Registered User
    Join Date
    09-01-2012
    Location
    Dublin Ireland
    MS-Off Ver
    Excel 2003
    Posts
    6

    macro to return max value in a time-series

    Hello,

    I am very new to this please excuse my ignorance. I have daily rainfall time-series and my objective is to find annual maximum daily rainfall. My data range from 1941 till 2004 so you can imagine why it is irksome to do it manually. Is there a macro that can extract the annual maximum value from each year taking into consideration that not every year has 365 days. I attach a sample.

    Regards

    Mohammed
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: macro to return max value in a time-series

    a pivot table will do that for you.

    see the example.
    Attached Files Attached Files
    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.

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: macro to return max value in a time-series

    @john456852

    what does it mean?

    mk as solved

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: macro to return max value in a time-series

    @john456852

    Thanks for the reply.

    @alsajim

    Maybe you also interested in the month.
    Attached Files Attached Files
    Last edited by oeldere; 09-01-2012 at 01:02 PM.

  5. #5
    Registered User
    Join Date
    09-01-2012
    Location
    Dublin Ireland
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: macro to return max value in a time-series

    thank you oeldere and john456852 most helpful

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: macro to return max value in a time-series

    Glad I could help. Thanks for the reply.

    If the question is solved, will you mark your question as solved?

    If you have (other) questions, on this item, just ask.

  7. #7
    Registered User
    Join Date
    09-01-2012
    Location
    Dublin Ireland
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: macro to return max value in a time-series

    question solved

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1