VBA find unique combinations from a list

[BigBeachBananas]

Hi,
I have a list of elements and I want a VBA to generate unique combinations, and a combination of the element and itself is possible. For example, we can have NS1_NS1, NS2_NS2, ect... but NS1_NS2 = NS2_NS1 so I'll only need NS1_NS2 or NS2_NS1 but not both.

 

[Fluff]

Duplicate to: Generating unique combination

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.