Closed Thread
Results 1 to 2 of 2

Distribution of values

  1. #1
    Registered User
    Join Date
    01-22-2019
    Location
    Novi Sad
    MS-Off Ver
    2016
    Posts
    10

    Question Distribution of values

    I need to distribute On hand qty to each warehouse by priority, having WHS 01 first in priority, and WHS 03 last.
    If SUM of On Hand of particular item is greater then or equals total sum of Stock QTY, i need to distribute On Hand SUM to all warehouses, so that SUM of On Hand matches the sum in each whs by priority. In that case the last whs gets the excess qty. And if sum of on hand qty is less than sum of stock qty, distribution goes by the same priority until total qty is depleted.

    Example with the result column attached.

    Help much appreciated

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,059

    Re: Distribution of values

    OP has posted in Commercial Services, so I am closing this thread
    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

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to plot frequency distribution graph with 2 distribution plots
    By escpolina in forum Excel Charting & Pivots
    Replies: 18
    Last Post: 08-16-2017, 10:22 AM
  2. Distribution of values
    By oddy73 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-11-2015, 06:53 AM
  3. Replies: 0
    Last Post: 04-08-2015, 10:21 PM
  4. I need to create a distribution plot that sums values
    By Calvin Buchanan in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-13-2013, 03:17 PM
  5. Replies: 1
    Last Post: 01-01-2013, 01:58 PM
  6. Student t distribution critical values
    By pittopitto in forum Excel General
    Replies: 0
    Last Post: 03-23-2007, 02:18 AM
  7. Random values from a Triangular Distribution
    By leebean337 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2006, 11:44 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