Greeting all,
I'm trying to find the most ordered combination of menu items.
The sample pic Ive uploaded shows the customer and what number from menu they ordered.
So customer 1 and 10 ordered the same items..
I want to find the top 5 combinations from over 2000 orders..
This table is just an example to make things easier.
Ive tried filters but cant find anything. Is there a countif formula that would work perhaps?
ANY help would be greatly appreciated

I'm trying to find the most ordered combination of menu items.
The sample pic Ive uploaded shows the customer and what number from menu they ordered.
So customer 1 and 10 ordered the same items..
I want to find the top 5 combinations from over 2000 orders..
This table is just an example to make things easier.
Ive tried filters but cant find anything. Is there a countif formula that would work perhaps?
ANY help would be greatly appreciated

