+ Reply to Thread
Results 1 to 5 of 5

Ordering of ingredients

  1. #1
    Registered User
    Join Date
    09-24-2018
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    9

    Ordering of ingredients

    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.
    Attached Files Attached Files

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Ordering of ingredients

    If I've understood {big If}

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    the above assumes, per sample, that you never have any base ingredients including in your master table that you wish to ignore when disclosing sub ingredients, if you do the above can be adjusted simply enough, we just need the confirmation.

  3. #3
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Ordering of ingredients

    on an aside, if you wanted to list the {unique} sub-ingredients in their actual RANK order (i.e. largest to smallest), you could swap out the above (C17) for the below, and copy down:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by XLent; 02-20-2019 at 06:00 AM.

  4. #4
    Registered User
    Join Date
    09-24-2018
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    9

    Re: Ordering of ingredients

    Thanks Xlent, works perfectly I really appreciate your assistance here. I added in you second suggestion re the sub-ingredients ... brillant. Kindest Regards.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,416

    Re: Ordering of ingredients

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Do I have enough ingredients
    By Markp2010 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-01-2018, 10:35 PM
  2. Master ingredients table
    By swarmcatcheruk in forum Excel General
    Replies: 8
    Last Post: 02-19-2018, 01:39 PM
  3. [SOLVED] How do I set up my recipe so that my ingredients and costs transfer over?
    By lfrudd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-12-2016, 11:21 PM
  4. [SOLVED] Formula for % of ingredients in a list?
    By Boomerj2 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-14-2014, 12:06 PM
  5. VBA Ordering User form for Purchase Ordering.
    By caf20012 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-10-2014, 01:50 PM
  6. [SOLVED] Want to know the ingredients of sumif formula
    By Sarangsood in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-05-2013, 05:21 AM
  7. Excel 2007 : Help with prices of ingredients used
    By louise2613 in forum Excel General
    Replies: 2
    Last Post: 06-18-2011, 05:36 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1