Closed Thread
Results 1 to 4 of 4

Max Value within a time range

  1. #1
    Registered User
    Join Date
    01-07-2023
    Location
    USA
    MS-Off Ver
    365
    Posts
    82

    Max Value within a time range

    Hello I would like to the max value "High within every range of time between 19:00 and 17:00 in a large data set

    Then with the next range of 19:00 to 17:00 mark the 7:00 time and mark if that value is higher then the previous max value found in the previous segment

    and continue down the data set

    thank you
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,852

    Re: Max Value within a time range

    This is a duplicate thread, and you are only allowed one thread per item on the forum.

    Carry on in your other thread (this one will probably get closed anyway !!)

    Pete

  3. #3
    Registered User
    Join Date
    01-07-2023
    Location
    USA
    MS-Off Ver
    365
    Posts
    82

    Re: Max Value within a time range

    thanks

    I will close the other one

    Thank You

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,866

    Re: Max Value within a time range

    That's not how it works. The other has a response. I restored the OP and this one gets closed.

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #2 about thread duplication.

    I am closing this thread, but you may continue here in the original thread

    Thread closed.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to check if a time range falls within another time range
    By Doopinator in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-01-2023, 08:16 PM
  2. Replies: 2
    Last Post: 06-26-2018, 09:10 PM
  3. [SOLVED] Check if range of time falls in another range of time
    By wafs in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-18-2018, 06:47 PM
  4. [SOLVED] COUNTIF Time Range - Time Range provided in Cells
    By Eaks77 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-02-2015, 11:12 PM
  5. [SOLVED] Counting values in a time range - when the time range crosses midnight
    By dlocos in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-24-2014, 04:27 AM
  6. Calculate if Time range appears in an other Time range
    By bajdr47 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-25-2013, 02:50 AM
  7. compare time values - current time with time in cell range?
    By wyattea in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-13-2013, 11:28 PM

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