I have a list of part's and their quantities. These parts are used to build sub assemblies and are also used with the sub assemblies to build the final product. These parts are used on multiple products and various sub assemblies. I have all the data of each product, their parts and then the parts of the sub assemblies. However I am looking for a way to build a "tier" list kind of thing in my excel sheet (could be in a table) that will show how many of each part I need if I were to order x of product A and x of product B.enter image description here