+ Reply to Thread
Results 1 to 4 of 4

Distributing a Stock Value to Multiple Cells (Rows) Based on Product Code

  1. #1
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Office 365
    Posts
    367

    Distributing a Stock Value to Multiple Cells (Rows) Based on Product Code

    Dear Experts,

    Please refer attached file,

    Column A Contains my Product Code,

    Column B Contains Customer Seq. by FIFO

    Column C Needed Qty by Individual Customer

    Column D Current Stock Against the Product Code (Please Be Informed, Product Code 123456789 – Available Stock is 4100 Pcs and by lookup it is duplicated against all same Product Code)

    Column E – Looking for a Support as below

    Against Each Product Code Line, Current Stock to be distributed as per Customer Needed Qty

    Example: -

    Product 123456789 Customer A Need 152 Pcs, 4100 Pcs can be distributed to this line.

    The Balance stock of 3948 Pcs to be allocated to next line in a same Product Code

    The Expected Results is been manually updated in Column F

    Please review and provide your valuable feedback on the same!

    Thanks & Regards,
    Rajeshkukmar R
    Last edited by Rajeshkumar R; 07-09-2019 at 02:19 PM. Reason: Query Resolved

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Distributing a Stock Value to Multiple Cells (Rows) Based on Product Code

    You can try this array formula in E2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Distributing a Stock Value to Multiple Cells (Rows) Based on Product Code

    Please try at E2
    =MAX(MIN(C2,D2-SUMIFS(C$1:C1,A$1:A1,A2)),0)

  4. #4
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Office 365
    Posts
    367

    Re: Distributing a Stock Value to Multiple Cells (Rows) Based on Product Code

    Dear Jacc /Bo_Ry,

    Thank You So Much for your quick Response & Support, The suggested formula's are working amazingly!

    Thanks & Regards,
    Rajeshkumar R

+ 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] Distributing Data in Multiple Cells Based on Multiple Ratios
    By SaadKiji in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-06-2016, 08:51 AM
  2. Distributing specified cells over multiple rows
    By sjaakexcel in forum Excel General
    Replies: 1
    Last Post: 02-15-2016, 05:57 AM
  3. [SOLVED] Distributing multiple cells from one column into multiple columns
    By danedw in forum Excel General
    Replies: 2
    Last Post: 10-16-2014, 05:17 AM
  4. Itemize Product based on quantity into Multiple Rows
    By sostenes in forum Excel General
    Replies: 2
    Last Post: 12-05-2012, 08:52 PM
  5. Replies: 3
    Last Post: 03-01-2012, 06:17 AM
  6. Replies: 2
    Last Post: 04-02-2009, 05:56 AM
  7. distributing data into multiple cells
    By jaspreet in forum Excel General
    Replies: 1
    Last Post: 05-28-2005, 04:31 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