Hi there, I am new to Excel and would appreciate if you can help me with my problem!
Data:
It consists of 2 columns namely “Order number” and “Product ordered”. For each order number, there will be multiple products being ordered.
Help:
I want to find out the number of times any 2 products are ordered together i.e. these 2 products have the same order number. This is to be repeated for all order numbers in the data. E.g. Suppose I have 4 products: A, B, C, D; then to find each possible pair arise from these 4 products: AB, AC, AD, BC, BD, CD.
Is there any way to find out the number of times any 2 products ordered together in all order numbers? Through any formula or if VBA is needed? Thank you so much!
Bookmarks