Hello all,
I'm having this problem with our company's products and what combinations are possible.
The following is the situation:
<tbody>
</tbody>
I have specified for each customer what products they have bought. And now I want to generate all possible product-combinations for each customer.
So, my output would be like this:
<tbody>
</tbody>
How can I do this in Excel?
Can this be done by using regular formulas/functions, or do I need VBA for this? (in case I need VBA, any suggestions how to start?)
Thank you very much!
~ Niels
I'm having this problem with our company's products and what combinations are possible.
The following is the situation:
CUSTOMER_ID | PRODUCT_ID |
1 | A |
1 | B |
1 | C |
1 | D |
2 | B |
2 | C |
3 | A |
3 | B |
3 | E |
3 | F |
3 | G |
<tbody>
</tbody>
I have specified for each customer what products they have bought. And now I want to generate all possible product-combinations for each customer.
So, my output would be like this:
CUSTOMER_ID | POSSIBLE_COMBINATIONS |
1 | A-B, A-C, A-D, B-C, B-D, C-D |
2 | B-C |
3 | A-B, A-E, A-F, A-G, B-E, B-F, B-G, E-F, E-G, F-G |
<tbody>
</tbody>
How can I do this in Excel?
Can this be done by using regular formulas/functions, or do I need VBA for this? (in case I need VBA, any suggestions how to start?)
Thank you very much!
~ Niels