Calculating equal batches

[Jessica231]

Hi guys,

I have a question regarding the formula to use in order to calculate equal batches.
To be clearer, my order being different every day and my batches needing to be equal and containing between 100 and 200 units, an automated formula would save me a lot of time in calculating the numbers every day.
Hope some of you will be able to help.

Thank you in advance

[Pepe Le Mokko]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Jessica231]

Sorry but I am very new here and not quite understand your reply. Could you please rephrase that in layman term for me.

[Pepe Le Mokko]

I don't see how one can be much clearer than that

[FDibbins]

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.