+ Reply to Thread
Results 1 to 5 of 5

Return MIN from a list After MAX is found - MIN number to the right of MAX

  1. #1
    Registered User
    Join Date
    03-22-2018
    Location
    USA
    MS-Off Ver
    365
    Posts
    3

    Return MIN from a list After MAX is found - MIN number to the right of MAX

    First Post, thanks in advance for help.
    I'm puzzled by this task and cant work around it.
    Looking for a way to find a MIN number to the right of a MAX number in a list.
    List will always change so the whole list needs considered.
    Thanks
    MINMAXEX.jpg

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Return MIN from a list After MAX is found - MIN number to the right of MAX

    Perhaps
    =MIN(INDEX(1:1,,match(B2,1:1,0)+1):XFD1)
    in B3
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Registered User
    Join Date
    03-22-2018
    Location
    USA
    MS-Off Ver
    365
    Posts
    3

    Re: Return MIN from a list After MAX is found - MIN number to the right of MAX

    That did it!
    Thank you very much!

  4. #4
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Return MIN from a list After MAX is found - MIN number to the right of MAX

    . .

  5. #5
    Registered User
    Join Date
    03-22-2018
    Location
    USA
    MS-Off Ver
    365
    Posts
    3

    Re: Return MIN from a list After MAX is found - MIN number to the right of MAX

    For future info, what is the :XFD1 represent?
    Thanks. ( last in row Got it! )
    Last edited by RidgeRunner; 03-22-2018 at 08:48 AM.

+ 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] Return TRUE if cell value is found in a list
    By Smally in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2016, 10:21 AM
  2. [SOLVED] Return Column Number when specific text is found
    By Simon.xlsx in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-29-2014, 12:20 PM
  3. Find all matches for one cell and when a match found return a ref number VBA
    By ch_abs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2014, 06:15 AM
  4. [SOLVED] Look for a list of strings in sentence and if found, return a value
    By chemisiq in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-25-2013, 08:14 AM
  5. [SOLVED] If specific text is found in cell, then return a number
    By csch123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-31-2013, 05:07 PM
  6. [SOLVED] find duplicate number and return total found
    By HelpHelpHelp in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-26-2012, 08:27 AM
  7. [SOLVED] Return ROW number from qa found range
    By Mike in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2006, 09:55 AM

Tags for this Thread

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