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
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
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
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks