+ Reply to Thread
Results 1 to 3 of 3

Distribute stock to requirements until it becomes zero.

  1. #1
    Registered User
    Join Date
    05-21-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    73

    Distribute stock to requirements until it becomes zero.

    Hi,

    Need your help with excel formula for Distributing stocks to requirements until it becomes zero.
    Attached a sample carrying input in sheet1 and expected result (and conditions) in sheet 2.
    Anyhelp is grealty appreciated.

    Thanks
    Babu.S
    Attached Files Attached Files
    Thanks
    Babu.S

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Distribute stock to requirements until it becomes zero.

    =MAX(0,MIN(C2,C2-(VLOOKUP(B2,E$2:F$6,2)-SUMIF($B$1:B1,B2,$C$1:C1))))
    in D2 and copy down

  3. #3
    Registered User
    Join Date
    05-21-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    73

    Re: Distribute stock to requirements until it becomes zero.

    Thanks yudlugar. it works.

+ 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. Identify the earliest expiry date on stock based on current stock levels
    By julie86xx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-10-2013, 01:08 AM
  2. Replies: 4
    Last Post: 01-29-2013, 02:26 AM
  3. Replies: 0
    Last Post: 10-28-2012, 07:22 AM
  4. Replies: 0
    Last Post: 09-25-2012, 09:39 AM
  5. Can I have Excel count up my stock requirements?
    By marknorton in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-29-2008, 10:57 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