Find most combinations of numbers.

[MPFX2022]

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

 

[bebo021999]

With VBA, If you are open, call me back (or tesrt code in #6 from Kevin)
With formula, using helper columns:
A-D: original data
F-I: sorted data
K-N: results

Loading Google Sheets

 

[BrerRabbit]

Thanks heaps for reply, but this wont work for what I need. The thing is each number represents an item. eg 4 = Caesar salad, 21 = pancakes. So sum of numbers could be multi combinations. eg 5+10 + 6 = 21. and so does 8+12+1 etc etc... I had thought of your method.
What I need is to find how often the combo of individual numbers comes up.
So Customer 1 and Customer 10 both ordered the same thing. items 4, 8, 9. So this = twice I need to find how often each combo comes up. Hope this makes sense??

It took a little bit for me to wrap my head around what you needed, and I think I have it. Feel free to give me a huge thumbs down if I haven't.

There's a few steps here:

SORT
You have to sort each row first either from ascending to descending or vice versa.
I46 = SORT(E46:G46,1,1,1)

COMBINATION
Then concatenate each sorted section.
M46 =CONCATENATE(TEXT(I46,"dd"),TEXT(J46,"dd"),TEXT(K46,"dd")). I used the Text format for a smoother look, but you don't need to.

COUNT
You need to count how many of each combination there are.
=IF(M46<>"",COUNTIF($M$46:M46,M46),"0")

1st, 2nd & 3rd
=LARGE(O46:O55,ROW(A1))

Each formula can be dragged down as many times as you need.