I want to work out the individual ingredients and their % in the Batch and then ranking of each individual ingredient from largest to smallest.
In this exercise you have 5 Base ingredients column C cells C6 to C10 which combine to make the Batch. However, each Base ingredient is made up of various Sub Base ingredients as you can see in column I, starting at cell I6.
Furthermore, some base ingredients have the same sub ingredients, which will need to consolidated in reporting the Batch % and rank.
From cell B16 I have inserted the headers of what I am trying to work out.
Thanks for your help.
Bookmarks