Dear Chihiro,
Thanks for your suggestions and solutions by using solver.
I tried to add more columns for containers & rows for items and it is not working perfectly.
I think dynamic solution may not be possible.
Let us see anybody is coming with a different solution for this.
You may suggest...
Dear Chihiro,
Thanks for your reply.
Yes, change in the weight for CD & OP is a sorting mistake.
The corrected file is attached herewith and the manual step for the solution is also shown in the file.
I am working on a small project to pack the items, hence the solution required. The number of...
Dear Friends,
I would like to get your suggestions to solve the following problem by using M Code or power query.
How to pack the items of Table 1 in minimum number of carton subject to
1. Total weight in a carton should be max of 25 kgs.
2. In a caton max 5 items can be inluded.
3.The...
Dear vletm,
Yes I understood that cross posting is not a good practice. If required, the cross posting can be done with mention of cross posting in the message and also give the the link of posting from other forum. Also post the solution if getting from the other forum in this forum.
Thanks...
Dear VLETM,
Yes, I understood the rules and cross psoting is not allowed. this was pointed out by ALI and accepted.
I am a new user and I was not aware about this and will not repeat hence forth.
If you can give a solution for my prblem with formulas, it will be fine.
Thanks
JP
Dear Friends,
I am having a table with pack nos, items & weight.
I need to regorganise the table based on the pack no. in a row of maximum 5 items.
The file is attched.
Awaiting for your solutions.
Thanks
Jayapresad
Dear Mr. Peter,
Thanks your solutions.
I will try it now.
Could you please suggest any solutions by using formulas, so that the same can be copy & pasted used for a bigger range and we will get solutions automatically.
Thanks
Jayapresad.B
jayapresad@gmail.com
Dear Mr. Peter,
Thanks your solutions.
I will try it now.
Could you please suggest any solutions by using formulas, so that the same can be copy & pasted used for a bigger range and we will get solutions automatically.
Thanks
Jayapresad.B
jayapresad@gmail.com
Dear Friends,
Can anyone suggest a solution with formulas in excel.
How to pack items in the range with minimum number of carton subject to
1. Total weight in a carton should between 20 kgs to 30 Kgs.
2. In a caton max 5 items can be inluded
Please see the attached file.
Thanks
JP
Dear Sirjb7,
Thanks for your suggestion.
It is not like that.
Refer your example.
Search one item Sirbj7. You can find the item some where in the list.
I want to take that item Sirbj7 to left side box. The data is different items and not repeating at all.
Hope you understood this...
Dear Olemiss,
That is difficult to do copying each item every time.
I think, if we use tick box next to each item and select the tick box.
The tick boxed items should be copied to another work sheet.
Is this possible by using excel formula or is it required to use Macro?
If macro is...
The data is like below.
Item code Description Rate.
The total data will be around 300 lines.
I want to select 10 or 15 items based on description.
Thanks
Jayapresad
Pl help me to solve the following issue.
I am having a large no of excel data in a work book.
I want to select few(10 or 15) data from the master data based on some criteria for further process.
How to do this?
Thanks
Jayapresad