Find number of possible combinations in a list - vba

Good night people!

I would like some help to develop some technique to find how many combinations I have within an existing list.

Example:

ORDER A - ITEM 1
ORDER A - ITEM 4
ORDER A - ITEM 8
ORDER B - ITEM 4
ORDER B - ITEM 1
ORDER C - ITEM 4
ORDER C - ITEM 8
ORDER C - ITEM 5
ORDER C - ITEM 3
ORDER D - ITEM 8
ORDER D - ITEM 4

My problem is trying to find out for example how many orders I have with items 4 and 8 in the same order and so on. An analysis of the mix of items on each order, I have tried everything here but I have not yet succeeded ... The problem too and that there would not always be the sequence of the same items ... In my head it would practically look like:

ITEM 4 AND ITEM 8 - 3 ORDERS
ITEM 1 AND ITEM 4 - 2 ORDERS
ITEM 4, ITEM 8 AND ITEM 1 - 1 ORDER

Adding that I would need to find subcombination within a combination as well. I am attaching my base to facilitate

Obs. I have an average of 18000 different items ...

Forgive my English, I still haven't found a solution in BR.

Try entering the following formula in Col C and copying down: Note, it will take time to process:

Please Login or Register  to view this content.

I found 660 items were duplicate up to 6x in your data

Okay, but how can that show me the combinations?

Sorry but I didn't understand it very well

I focused on providing duplicates, I misread the original question.

I did not know this technique, I am trying to understand here because it does not contain many tutorials in Portuguese .. But I know a little bit of Power bi, I will try.

Okay, in theory I have all the combinations of items on that list, but how do I find the number of orders on each one?

And in the case this combination should show for example about 3 items:

ITEM 4, ITEM 6, ITEM 7

ITEM 4, ITEM 6

ITEM 4, ITEM 7

ITEM 7, ITEM 6

Right?