Distribution in excel


I want to allocate Stock available (Column K) qty as per Sales order – Line item combination (basis first come first serve basis).


Sales order qty – 5169

Available stock qty – 3500

* Allocation should happen basis first Sales order and first line item combination.


Please guide solution to it…

By: Ayush

38 thoughts on “Distribution in excel

  1. cheap jordans

    There are some fascinating points in time on this article however I don抰 know if I see all of them center to heart. There’s some validity but I’ll take hold opinion till I look into it further. Good article , thanks and we wish more! Added to FeedBurner as well

  2. yeezy boost 350 v2

    The next time I learn a weblog, I hope that it doesnt disappoint me as a lot as this one. I mean, I know it was my option to read, however I truly thought youd have one thing interesting to say. All I hear is a bunch of whining about one thing that you could repair when you werent too busy looking for attention.

  3. http://tinyurl.com/tu3lbtr

    Unquestionably believe that which you stated.
    Your favorite reason seemed to be on the net the simplest thing to be aware of.
    I say to you, I certainly get annoyed while people consider worries that they plainly do not
    know about. You managed to hit the nail upon the top and also
    defined out the whole thing without having side effect , people can take a signal.

    Will probably be back to get more. Thanks

  4. plenty of fish dating site

    Hello there, just became alert to your blog through Google,
    and found that it is really informative. I’m gonna watch out for brussels.

    I’ll appreciate if you continue this in future.
    A lot of people will be benefited from your writing.

  5. jordans

    There are definitely a lot of details like that to take into consideration. That may be a nice point to convey up. I offer the ideas above as basic inspiration but clearly there are questions like the one you carry up the place crucial thing might be working in sincere good faith. I don?t know if best practices have emerged round issues like that, however I am sure that your job is clearly recognized as a fair game. Both girls and boys really feel the impact of only a second抯 pleasure, for the rest of their lives.

  6. lebron shoes

    This web site is really a walk-by way of for all the info you wanted about this and didn抰 know who to ask. Glimpse here, and you抣l definitely discover it.

  7. ps4 games

    After checking out a handful of the blog articles on your blog, I seriously like your technique of blogging.
    I added it to my bookmark website list and will be checking back in the near future.

    Take a look at my website as well and tell me what you

  8. quest bars cheap

    I know this if off topic but I’m looking into starting my own weblog and was wondering what all is
    needed to get set up? I’m assuming having a blog like
    yours would cost a pretty penny? I’m not very web savvy so I’m not 100% certain. Any suggestions or advice
    would be greatly appreciated. Kudos

  9. ps4 games

    For most up-to-date news you have to visit world-wide-web and on web I found this web site as a most excellent web
    site for most up-to-date updates.

  10. Harlan Benck

    This is the right blog for anyone who wants to find out about this topic. You realize so much its almost hard to argue with you (not that I actually would want?HaHa). You definitely put a new spin on a topic thats been written about for years. Great stuff, just great!

  11. nike shoes

    I simply wanted to compose a small word in order to express gratitude to you for all of the fantastic concepts you are showing here. My considerable internet search has now been honored with useful strategies to share with my relatives. I would say that we readers are really endowed to live in a notable site with very many wonderful professionals with very helpful points. I feel really privileged to have encountered your webpage and look forward to so many more fabulous moments reading here. Thank you once again for all the details.

  12. hermes birkin

    I enjoy you because of all your efforts on this site. Ellie really loves participating in investigation and it’s really obvious why. My partner and i learn all concerning the lively manner you provide very helpful solutions via the blog and as well as increase participation from people on that subject so my child has been understanding a whole lot. Take pleasure in the remaining portion of the year. You’re doing a brilliant job.

  13. adidas superstars

    My wife and i have been quite more than happy that Jordan managed to conclude his research from the ideas he discovered when using the web pages. It is now and again perplexing to simply choose to be offering solutions that many most people could have been trying to sell. So we consider we need you to be grateful to because of that. Those explanations you made, the straightforward blog navigation, the friendships you can give support to engender – it is all fantastic, and it is helping our son and our family understand this topic is fun, and that is truly fundamental. Many thanks for all the pieces!

  14. vapormax

    Thank you for your whole efforts on this website. Debby loves going through internet research and it’s really obvious why. We all notice all of the powerful tactic you produce very helpful information by means of the blog and even improve response from other ones about this content then our favorite girl has been discovering a lot. Take pleasure in the remaining portion of the new year. You’re carrying out a terrific job.

  15. Google SEO Expert

    Hello, Neat post. There’s a problem with your web site in web explorer, may check this… IE nonetheless is the market chief and a good section of other people will leave out your excellent writing because of this problem.

  16. Gaylord

    Hi! I’ve been reading your website for a while now and finally got the courage to go ahead and give you a shout out from Atascocita Tx! Just wanted to tell you keep up the good work!

  17. nike air max 270

    I wish to express thanks to the writer for rescuing me from this issue. Right after browsing through the world-wide-web and meeting tricks which are not powerful, I believed my life was gone. Living without the strategies to the issues you’ve resolved all through your entire article is a critical case, and ones that might have in a negative way affected my entire career if I had not come across the website. Your personal ability and kindness in dealing with every item was tremendous. I am not sure what I would have done if I hadn’t come across such a subject like this. I can at this point look forward to my future. Thanks for your time very much for this specialized and results-oriented guide. I will not hesitate to refer your web page to any person who should receive guidelines about this subject matter.

  18. sling tv

    Ahaa, its good dialogue on the topic of this piece of
    writing here at this web site, I have read all that, so at this time me also commenting at this place.

  19. Todd Snively

    Wow, marvelous blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your website is fantastic, let alone the content!

  20. Todd Snively

    I like the valuable info you supply on your articles. I will bookmark your weblog and check once more right here regularly. I am relatively sure I will be informed plenty of new stuff proper here! Best of luck for the next!

  21. calvin klein

    Thanks so much for giving everyone a very spectacular chance to discover important secrets from this website. It’s usually so useful and as well , jam-packed with a great time for me and my office peers to visit your site the equivalent of thrice in one week to find out the new things you will have. And definitely, we’re actually fascinated with the beautiful information you serve. Selected 1 ideas in this posting are undeniably the most effective I have had.

  22. sling tv

    I like the helpful info you supply on your articles.

    I’ll bookmark your weblog and test once more right here frequently.
    I’m rather sure I will learn a lot of new stuff right right here!
    Good luck for the following!

  23. kobe shoes

    I wish to show appreciation to the writer for bailing me out of this condition. As a result of exploring through the the net and obtaining notions that were not productive, I assumed my entire life was done. Being alive without the presence of approaches to the problems you’ve resolved as a result of this article content is a crucial case, and the kind which may have in a wrong way affected my entire career if I hadn’t noticed your site. Your actual natural talent and kindness in controlling all things was excellent. I’m not sure what I would’ve done if I had not discovered such a subject like this. I can at this moment look ahead to my future. Thanks very much for the reliable and effective guide. I will not hesitate to recommend your blog post to anyone who should have guidelines about this topic.

  24. sling tv

    After looking at a few of the blog articles on your web site,
    I honestly appreciate your way of writing a blog.
    I bookmarked it to my bookmark site list and will
    be checking back soon. Take a look at my web site too
    and tell me your opinion.

  25. yeezy shoes

    I’m writing to let you know what a impressive discovery my child had going through your blog. She picked up a wide variety of things, including how it is like to have an awesome coaching style to have the rest just fully understand chosen hard to do matters. You really surpassed people’s desires. Many thanks for distributing such practical, safe, educational not to mention easy tips about this topic to Emily.

  26. sling tv

    Right now it seems like Expression Engine is the preferred blogging platform available right now.
    (from what I’ve read) Is that what you’re using on your blog?

Leave a Reply

Your email address will not be published. Required fields are marked *