can you help me expand on this further by adding a pallet count to this i.e. 30 full boxes = 1 pallet

Thanks.



=INT(A2/B2)&" full box of "&B2&" and "&MOD(A2,B2)&" inner's"

Edit Mod

This post is related to https://www.msofficeforums.com/excel...pack-qtys.html

Is it like the attached that you want?

Attached Files

Boxes_2.xlsx (11.0 KB, 11 views)

Sorry could you show me how to apply it to this current set-up

Attached Files

Test.xlsx (10.4 KB, 14 views)

Please give so many examples (including expected results and form of result) so that I have a real chance to test.
I assumed pallet size always would be 30 as you didn't mention otherwise.

G2 and H2 use VLOOKUP to return the specific pack sizes of the product. the current formula being used is....

=INT(H2/I2)&" full box of "&I2&" and "&MOD(H2,I2)&" inner's "

I just want to add pallets to this, the pallet qty will be determined by the VLOOKUP as is the pack Qty.

Maybe like shown in column K if you can accept a helper column (column N)

Attached Files

RC Out_2.xlsx (41.6 KB, 9 views)

@kubi

Hi
if you have a new question, even pertaining to an existing thread, it's always best to start a new thread eventually adding a link.
This will give you a better chance of getting an answer

I did it for you this time

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I am having trouble with column M returning a carton count even if a full pallet has been picked which then makes the final count wrong.

Inners and pallet counts work fine, just carton picks needing fixing.

Any help?

Attached Files

Test#2.xlsx (11.2 KB, 10 views)

It seems difficult for you to give illustrative examples with expected results.

Attached Files

Boxes_3.xlsx (12.2 KB, 13 views)

I thought it rather self explainitory what I was having trouble with sorry, but yes this apares to be working.

Thank you.