I have two columns (ID and Part Number) and am looking to identify all possible "Part" combinations that we ship out.
ID = Individual Sales Orders
Part Number = Individual Part Numbers within each Sales Order
Would like to see:
Part 1234 and 5678 = Count of 80
Part 5678 and 3333 = Count of 90
Part 1234 = Count of 110
Shipping Parts 2014-2015.xlsx
Any help on how I can put a formula together to calculate this would be great.
There are 328 distinct part numbers, which means there north of 50,000 2-element combinations. I don't think it would be practical to use formulas.
Entia non sunt multiplicanda sine necessitate
Thanks shg for your reply. If not a formula, any other suggestions on how one would find a solution?
The alternative is a macro (VBA). Some kind soul may be willing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks