Need to Find Items Most Frequently Purchased Together

[BiggerOnion]

I have a list of purchase ids and a list of product ids and I would like to see what products are most commonly purchased in pairs. Is there an easy way to do this? I tried using a SUMPRODUCT function but I most have done something wrong because the numbers are not making sense. If anyone has recommendations on how to do this (with or without the SUMPRODUCT function), I would greatly appreciate it.

[alansidman]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[BiggerOnion]

Here is an example of the type of data I would be working with and the example output I am looking for.

Please let me know if you need any further info. Thank you so much for your help!

[BiggerOnion]

Does anyone have any tips or suggestions? Thanks.