Value Distribution based on Criteria

    Hi guys,

    Need your help!
    My problem is how am I gonna distribute my remaining values based on my total output. then if the remaining value is 0 and my total output does not meet it yet, it will continue on its next cell.

    B1:F1 is my remaining Values
    G3:G11 is my Total output
    B3:F11 is where I need to put your formula.


    ABCDEFG
    1
    		41.538.596.542.5125.5
    2G056I076K090H060M113OUTPUT
    31-DEC43
    42-DEC42
    53-DEC44
    64-DEC49
    75-DEC46
    86-DEC40
    97-DEC0
    108-DEC0
    119-DEC0
    12TOTAL:00000264




    This is my goal for my table:


    ABCDEFG
    1000080.5
    2G056I076K090H060M113OUTPUT
    31-DEC41.51.543
    42-DEC37542
    53-DEC4444
    64-DEC47.51.549
    75-DEC41546
    86-DEC4040
    97-DEC0
    108-DEC0
    119-DEC0
    12TOTAL:41.538.596.542.545264

    Hello,


    Why don't you attach your sample file ... this would make everything easier ... for everybody ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Haha 1

    Thanks for the sample file :)


    Understand you need to come up with some kind of distribution ...


    But, what are the rules or the constraints to go by ...???

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    For example:
    for todays output (7-dec) of my 2 shifts are 22 on 1st shift and 23 on 2nd shift output. total of 45 output - DATABASE Sheet
    and we're currently working on M113 which is my SW code - Database sheet
    as you can see on my "with data or without data" sheet, I use sumproduct function just to get my whole day output.
    Also in H060 on "with data" sheet, I have a total of 42.5 qty in there, on 5th of December we already consumed it before we finish our whole day shift so that is the time (which is yesterday) where we start the production of M113...

    sorry having a problem to explain it English..

    See message in your other thread :


    Post
    Need help on lookup/index/match formula or worse need to VBA
    Hello guys,

    Newbie/Noob here, need your hand on this one:
    ABCDE
    1 H058B057C062H059
    21-Nov18,000
    32-Nov2,0003,000
    43-Nov 20,00015,000
    54-Nov 10,00015,000
    B1:E1 is my SW Code
    B2:E5 are my quantity

    need to do something like xlookup but don't know how to do it. Here's my question,
    on another sheet, if my lookup value is on the Column A, how can I get its all quantity and SW Code using a formula or a VBA? Something like this:
    Date:SW CodeQuantity
    3-NovB05720,000
    C06215,000
    3-Nov is my lookup value
    B057 &…
    Rr111

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login