• 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.

Search results

  1. J

    Container assignment with constraint.

    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...
  2. J

    Transpose of a table with conditions

    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
  3. J

    How to sort data based on conditions

    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
  4. J

    Hi,

    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
Back
Top