+ Reply to Thread
Results 1 to 4 of 4

Remaining Containers based on Quantity balance

  1. #1
    Forum Contributor
    Join Date
    01-31-2011
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    191

    Remaining Containers based on Quantity balance

    Hello experts,

    Can you please help me find the number of containers remaining base on the Quantity balance of my materials.

    Please find attached file for your reference.

    Thank you so much to any help that you can render.

    thong
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,044

    Re: Remaining Containers based on Quantity balance

    I used this, copied down...
    =ROUNDUP(F2/H2,0)

    Assuming your expected answers are in column G, Im not sure how you goet to some of them?

    G
    H
    I
    1
    No. of Containers
    Quantity in each container
    No. of Containers Remaining
    2
    10
    219
    10
    3
    9
    230
    9
    4
    12
    40
    7
    5
    4
    725
    1
    6
    1
    20
    1
    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

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Remaining Containers based on Quantity balance

    crosspost

    http://www.mrexcel.com/forum/excel-q...e-balance.html
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  4. #4
    Forum Contributor
    Join Date
    01-31-2011
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    191

    Re: Remaining Containers based on Quantity balance

    Those Numbers that I provided are the actual numbers and containers of each individual materials when I received them.
    I want to know the number of remaining containers when we take some quantities. Its time consuming that every end of the month Im going to physically count the numbers of containers for each materials.

    Thanks

+ 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. Replies: 6
    Last Post: 06-14-2018, 03:05 PM
  2. [SOLVED] Highlight cell based on total quantity value based on repeated order numbers
    By PWilson0727 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2014, 02:02 PM
  3. Replies: 6
    Last Post: 09-17-2013, 08:57 PM
  4. Trying to count the number of temps based on dates and matching containers
    By Kfeisse1 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-20-2010, 01:48 PM
  5. Replies: 5
    Last Post: 11-23-2009, 06:24 PM

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