+ Reply to Thread
Results 1 to 5 of 5

Create a sub-list from a larger list and find the MIN value in another column

  1. #1
    Registered User
    Join Date
    04-10-2013
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2021
    Posts
    17

    Create a sub-list from a larger list and find the MIN value in another column

    I am looking for a formula to search two columns.

    1) The first column needs to be search to match a text string.
    2) If the text string matchs, I need excel to evaluate the number in the second column and find the MIN value of all numbers associated with the text string.

    So:

    Joe 50
    Jim 12
    Joe 10
    Rob 25
    Jim 8
    Rob 99

    When searching for "Joe", the function would return 10. When searching for "Jim" the function would return 8. For "Rob", it would return "25".

    Can anyone help?

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Create a sub-list from a larger list and find the MIN value in another column

    ahenobarb,

    Welcome to the Excel Forum.

    If Joe was in cell A1.

    In cell E1, enter the following formula:
    =MIN(A1:A100=D1,B1:B100) confirmed with CTRL + SHIFT + ENTER

    Then the formula in cell E1 should look like this:
    {=MIN(A1:A100=D1,B1:B100)}

    Then enter a name in cell D1, say, Jim

    And, cell E1 will display 8


    Detach/open sample workbook FindMin - ahenobarb - EF987407 - SDG15.xls
    Last edited by stanleydgromjr; 02-06-2014 at 02:57 PM.
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  3. #3
    Registered User
    Join Date
    04-10-2013
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2021
    Posts
    17

    Re: Create a sub-list from a larger list and find the MIN value in another column

    Perfect!! Thank you so much!

  4. #4
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Create a sub-list from a larger list and find the MIN value in another column

    ahenobarb,

    Thanks for the feedback.

    You are very welcome. Glad I could help.

    And, come back anytime.

  5. #5
    Registered User
    Join Date
    04-10-2013
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2021
    Posts
    17

    Re: Create a sub-list from a larger list and find the MIN value in another column

    Of course, since I still have hair that I haven't pulled out, I had to tinker with the formula a bit to search only part of a string. For what it's worth and the sanity of those who come after, here's the formula I used:


    =MIN(IF(MID(B:B,9,46)=Sheet1!D3,C:C))

    confirmed with ctrl+shift+enter

+ 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] Finding a specific list of names inside larger list
    By Boxed in forum Excel General
    Replies: 7
    Last Post: 09-13-2013, 06:46 PM
  2. [SOLVED] Drop-down list Populated by a Subset of a larger list
    By RJH in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-11-2010, 07:17 AM
  3. Create sublist from larger list
    By writeguy37 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-27-2008, 11:52 AM
  4. Cross ref. emails from small list with a larger list?
    By DiscoStu in forum Excel General
    Replies: 2
    Last Post: 09-27-2007, 07:21 PM
  5. [SOLVED] Pulling a Summary List from a Larger List
    By Stephen - Dallas in forum Excel General
    Replies: 2
    Last Post: 05-03-2006, 09:55 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