+ Reply to Thread
Results 1 to 3 of 3

Return the Earliest time in a range based on a min value

  1. #1
    Registered User
    Join Date
    10-05-2013
    Location
    Lancaster, CA
    MS-Off Ver
    Excel 2010
    Posts
    13

    Question Return the Earliest time in a range based on a min value

    I need a formula to return the earliest time where another row in the same column meets or exceeds a min specified value. I've tried multiple attempts at using INDEX-MATCH. But, if a Check Text cell was empty, it would treat the Value text ("") as having met the check and then use that column (which is wrong because no text specified means the time is not valid). So, I tried to have it check for the min value and a lack of "" for Value, but couldn't get that to work either. Thanks for your help!

    Check Text yes yes yes yes
    Times 11:00 AM 12:00 PM 1:00 PM 2:00 PM 3:00 PM
    Value 2 4 8 10


    Min Value 6
    Returned Time I would like B5 to return 1:00 PM because the first instance greater or equal to 6 in row 3 where row 1 is not empty is at 2:00 PM

    EarliestbasedonfirstMinValue.xlsx
    Last edited by afgoody; 07-23-2014 at 10:09 AM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: Return the Earliest time in a range based on a min value

    Array* formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    *) means Ctrl+Shift+Enter commited one

    PS. You expect 2PM (not 1PM) as result, don't you?
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    10-05-2013
    Location
    Lancaster, CA
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Return the Earliest time in a range based on a min value

    That did it...thanks!

+ Reply to 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 look up value and return the earliest date?
    By ea223 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-01-2013, 08:27 PM
  2. Return a value based on a time range
    By cfreedman in forum Excel General
    Replies: 1
    Last Post: 07-01-2012, 02:16 AM
  3. Can Excel return the earliest date using =IF?
    By jareduk in forum Excel General
    Replies: 7
    Last Post: 04-01-2009, 04:59 AM
  4. Return the earliest day of a month
    By vickyho1008 in forum Excel General
    Replies: 1
    Last Post: 07-07-2008, 04:49 AM
  5. Vlookup to Return Earliest Date
    By marco168 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-05-2007, 11:12 AM

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