I have a long list of parts with duplicates and each part can go to multiple units. I need to know how many parts to order for any given number of units.
This is what some of my data looks like (it is a very long list):
Please Login or Register to view this content.
This is what I want Excel to make it look like:
**Edit: So with the new output I know that if I want one of each unit, I need to order 4+6+3+7=20 Part 1's.Please Login or Register to view this content.
Bookmarks