Order Sets and Arrays

Hello, I was hoping to get some help on a little problem I am having. It is very convoluted, but I will summarize with a little example:

We have customers who order items in a specific order (Product X first, Product Y second, Product Z, etc...)

As it stands, no one orders in the same way and we want to try to standardize this process.

I have a list of about 600 products, such as:

• Product X
• Product Y
• Product Z
• Product 300...

I need to know the top 10 products ordered together. (the idea is that this variable will be changeable, and I can see the top 11, 12, or even more)

My idea is to generate a list of arrays in a new sheet with 10 products in them from the list; ie {Product A, Product B, Product C...Product K}, (noting to alphabetize the array entries and then remove duplicates form the row)

With this list, I will use each entry to check with each customer if they're order set array equals this list (again, alphabitized and duplicates removed to ensure comparison).

My question:

• Is this the most optimal way to do this? ... I am not even sure it would get me where I want to be. As it seems like an amazing amount of coding and formulas; but through my searching I haven't found this unique example.
• How can I generate my unique, alphabetized arrays for comparison (ie: 10x10, 9x9, 8x8...)

Any help is much appreciated!

Thanks,
Jon