+ Reply to Thread
Results 1 to 3 of 3

Adding date/time to minimum and maximum flow values

  1. #1
    Registered User
    Join Date
    07-06-2012
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2007
    Posts
    2

    Adding date/time to minimum and maximum flow values

    I am putting together a spreadsheet on Excel 2007 with data that I am exporting from a program called Flowlink.

    Flowlink is a program for monitoring water flow, head height, pH, etc. in municipal water systems.

    I have date/time in column A, flow rate in column B, and head height in column C.

    The data is listed in 10 minute intervals for a full month, on my spreadsheet, the date parameters are from 5/1/2012 0:00
    to 5/31/2012 23:50.

    I have a line for minimum flow using =MIN(C17:C4480) , maximum flow using =MAX(C17:C4480) , and average flow using =AVERAGE(C17:C4480).

    What I want is, next to the cell that shows the minimum flow, I want to have the date/time of the minimum flow event automatically pasted into the next cell. In other words, I have the spreadsheet programmed to tell me what the minimum flow was, but I need it to tell me when the event occured.

    Can somebody help me please?

    Thanks.

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Adding date/time to minimum and maximum flow values

    Try

    =INDEX(A17:A4480,MATCH(MIN(C17:C4480),C17:C4480,0))

    If there are multiple minimum flow events then this will return the first instance.

  3. #3
    Registered User
    Join Date
    07-06-2012
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Adding date/time to minimum and maximum flow values

    Jason, you ARE THE MAN! Dude, that worked like a charm! Thanks for your help brother!

+ 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