+ Reply to Thread
Results 1 to 7 of 7

Help on Conditional Min Function

  1. #1
    Registered User
    Join Date
    11-10-2012
    Location
    vietnam
    MS-Off Ver
    Excel 2003
    Posts
    3

    Help on Conditional Min Function

    Hi Everybody
    I got trouble making conditional Min formula and couldn’t come up with any solution.Could you kindly help advise on below case. Thank you very much !!
    At the column Min, find the smallest number for the column Qty Available for the item at FSC column.
    (if it’s F1653111- smallest number is 699). I use MINA function but problem is I have to go to every item (F1653111,F1655111,F2081034, ect….) to copy and paste the formula and that takes a lot of time.
    Could you help set up a conditional MIN formula that will automatically find the smallest number at the Qty avail column when the item changes? (for ex from 1655111 to 2081034 ect...)
    Thanks a lot in advance !!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-11-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    93

    Re: Help on Conditional Min Function

    You can use Pivot table

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Help on Conditional Min Function

    see if the attached will give you what you need?

    edit: sorry, didnt see that sandip had already suggested this
    Attached Files Attached Files
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    11-10-2012
    Location
    vietnam
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Help on Conditional Min Function

    Thanks sandiptemkar and Fdibbins.

    Can you elaborate more on the formula? I want to set up a conditional Min function that can automatically run when the item changes.Here you already have the Min value for each item,thus you can run Pivot. But what I need is the Min formula that can automatically fill in the Min clumn.
    Attached is the file for your ref. I want to fill in column Min but the list is too long for copying and pasting formula item by item.

    Thank you for your kind help !
    Attached Files Attached Files

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Help on Conditional Min Function

    you dont need to use a formula, just update the PT any time the data changes

  6. #6
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Help on Conditional Min Function

    If you want a formula try this in D2 copied down

    =IF(A1<>A2,MIN(OFFSET(C2,0,0,COUNTIF(A:A,A2))),"")
    Audere est facere

  7. #7
    Registered User
    Join Date
    11-10-2012
    Location
    vietnam
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Help on Conditional Min Function

    Thank you very much FDibbins and daddylonglegsfor your great help !

+ 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