Forum Discussion

A_SIRAT's avatar
A_SIRAT
Iron Contributor
Nov 07, 2020

Excel division

Hi,   I would like to be assisted with a formula that can calculate as per below;    1. Check the Quantity ordered for a given variety and then divide this amount by the maximum           pack rat...
excel
  • A_SIRAT's avatar
    A_SIRAT
    Iron Contributor
    Nov 09, 2020

    Detlef_Lewin 

     

    Hi,

     

    I have rephrased the excel question in a different way..." throwing a spanner in the works".

    The maximum that can be packed in a box in 1500. After a box is filled up, then the division continues downwards i.e. if the left over is 200 for Jenny for box nr 3, then this will be filled up by 1300 sylvia which is the next variety.

    I have attached an example file.

     

    Please assist and thank you for your efforts.

     

     

  • A_SIRAT's avatar
    A_SIRAT
    Iron Contributor
    Nov 07, 2020

    Thanks Detlef, Would you mind to explain how you worked it out with power query? Not familiar with power query.

     

    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Nov 07, 2020

      A_SIRAT 

      To view the query right click on the green table: Table... -> Edit query.

      On the right is a pane with the individual steps. Some have a gear icon which gives more detailed information then the formula bar.

      • A_SIRAT's avatar
        A_SIRAT
        Iron Contributor
        Nov 08, 2020

        Detlef_Lewin

        SergeiBaklan 

         

        Thank you  guys !

        Though I need to learn power query. Posting this question opened up a new chapter.

         

Resources