• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Divide the total count on the basis of batch size

A

amit_gupta123

Member
Hii All

I have a query regarding dividing the total count of an item on the basis of batch size. The original quantity gets divided into different parts and gets renumbered. To describe the query properly I am attaching herewith the file where in input is in col A B C and desired output is in yellow in col F & G

Regards
 

Attachments

  • sample.xlsx
    8.5 KB · Views: 5
Hi Amit -

Here's an initial shot at your requirement - it can be automated further and made a lot more flexible, but before I go off and spend a lot of time and effort on that, I want to be sure you need it ... perhaps all you wanted was a formula to derive the batch values?
 

Attachments

  • amit_gupta123 - DME.xlsx
    9.1 KB · Views: 2
Hii...thanks

It is near to the requirement. But the actual output I am looking forward to in the format I have provided that is in Column form.

First for a particular item the number of new items generated to be calculated and the count of items

For e.g. For Items A , 3 new items will be generated on the basis of Batch Size of 2500. As A1 for 2500, A2 for 2500 & A2 for remaining 438. In case if item count varies then new item count should change dynamically.

Really appreciate the time you invested

Regards
 
Gr8 Sir Narayan !!! You guyz are awesome....i practice in excel but its my dream I could gain knowledge atleast one percent of you have..Hats off

Would you pls advise which books and blogs to follow?

REgards
 
Hi ,

You might think that I am joking , but all that I have learnt , I have done so through this forum !

There are other forums too , such as :

MrExcel ( http://www.mrexcel.com/ )

Ozgrid ( http://www.ozgrid.com/ )

ExcelForum ( http://www.excelforum.com/ )

Apart from this , there are many other Excel blogs you can follow , starting with :

Jon Peltier ( http://peltiertech.com/ )

Debra Dalgleish ( http://www.contextures.com/ )

When you have mastered the content in all these , and still hunger for more , check out :

http://excelxor.com/

The following are somewhat more specialized sites , which apply Excel to specialized problems :

http://excelunusual.com/tag/unusual-excel/

https://newtonexcelbach.wordpress.com/

VBA is a totally different animal , and there are hundreds of sites which specialize in VBA.

Narayan
 
You must log in or register to reply here.
Back
Top