Hi all,
I have a spreadsheet that lists out the materials (and its compounds) that go into a master product
What I want is to have the spreadsheet automatically fill in the low and high range values of each compound by part number for the master product (listed in green on excel), based on the material compounds listed (compounds from Materials #1,Materials #2,etc) Example: I want to find what the lowest range and highest range number of Part Number 1111 for all the materials listed below the green area, which would be 0 and 100 respectively in this case.
It's easy enough to do this manually in the example but what if I had potentially 50 materials that could go into the master product?
Can someone provide some guidance on how to proceed?
Thank you!
Bookmarks