Forum Discussion
Excel Formula for box numbers
Need assistance to setup an box nr. pack list The maximum quantity that can be packed in a box is 1500 as per the list. After the first box of the first variety is filled up, any incomplete amoun...
Hello,
I got the issue, however your requirement is not clear enough,
what will happen for the variety in the next line such as (G6:I6), would you remove it? value in H5 will be 1500
Do you want it to be like this:
Jenny 1,500 1
Jenny 1,500 2
Jenny 1,500 3
Sylvia 1,500 4
Sylvia 1,500 5
Sylvia 1,500 6
Aurora 1,500 7
Aurora 1,500 8
Aurora 1,500 9
Hanna 1,500 10
Hanna 1,500 11
Hanna 1,500 12
Hanna 1,500 13
Hanna 100 14
I got the issue, however your requirement is not clear enough,
what will happen for the variety in the next line such as (G6:I6), would you remove it? value in H5 will be 1500
Do you want it to be like this:
Jenny 1,500 1
Jenny 1,500 2
Jenny 1,500 3
Sylvia 1,500 4
Sylvia 1,500 5
Sylvia 1,500 6
Aurora 1,500 7
Aurora 1,500 8
Aurora 1,500 9
Hanna 1,500 10
Hanna 1,500 11
Hanna 1,500 12
Hanna 1,500 13
Hanna 100 14
Let me explain myself better.
I receive an order like this ;
Variety ID Variety Name Quantity
10102 Jenny 3200
11102 Sylvia 5200
10002 Aurora 3900
10062 Hanna 7300
Each box can take a maximum of 1500.
So box nr.
1 = Jenny 1500
2= Jenny 1500
3 = Jenny 200
3 = Sylvia 1300
4 = Sylvia 1500
5 = Sylvia 1500
6 = Sylvia 900
and continuation.