Finding Item Combinations

Hi guys,

 

In brief, i have an example, where i have 20 stores (Column A, Store 1 being in cell A2 and Store 2 being in cell A21), in each store there is a two or more type of Point-Of-Sale units installed (Row 1, Unit1 being in cell b2, unit 12 being in cell b13) There are a total of 12 unit types.

What i need is a formula that can check each store for what combination of units are installed and give a unique value for that combination.

 

Objective: I want to find out what is the most common combination of units installed out of the 20 stores.

 

So i may find that combination 1 is present in 50% of the stores.

By: Moe

Leave a Reply

Your email address will not be published. Required fields are marked *