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.
Bookmarks