I am trying to compose a formula that tells me the most commonly sold products with other products, so i know what I should order to replenish stock. Lets say I have the following 4 sales
Sales order number/ products sold (it would be on separate lines)
0001 Apples and Milk
0002 Apples and Milk
0003 Nectarines and News Paper
0004 Bananas and Milk
When I go to reorder apples, I want a column that tells me that Milk was ordered twice with it, so I can kind of profile my stock based on the number of orders that hit that criteria (in this case, 2). This is a simplistic example, and I thought about a kind of countif formula but can't quite get it. Any thoughts would be appreciated.
Bookmarks