Hello, guys!
I need your help once again.
I tried to solve it myself using Pivot Table, INDEX/MATCH and even MS Query/SQL with no avail... It's apparently simple but I can't figure it out.
So, I have two columns: Column A with product names and Column B with raw materials.
I need some function, VBA, Pivot Table, anything, to check:
1) How many raw materials each product has in common.
2) What the products are.
Let me illustrate it to you:
Prod RawMat
W A
W B
W C
W D
X B
X F
X G
Y C
Y G
Y H
Z B
Z C
Z G
Result expected
- Product W has 2 raw materials in common (B and C). Corresponding products for B= X and Z. For C= Y and Z.
- Product X has 2 raw materials in common (B and G) . Corresponding products for B= W and Z. For G= Y and Z.
- Product Y has 2 raw materials in common (C and G). Corresponding products for C= W and Z. For G= X and Z.
- Product Z has 3 raw materials in common (B, C and G). Corresponding products for B= W and X. For C= W and Y. For G= X and Y.
I hope I have made myself clear.
Thanks in advance for your help!
Rgds,
Gustavo.
Bookmarks