Give random unique set of 9 pairs

[MaxTrax]

Hi People,

I have a set of 58 pairs (I’m using paired numbers here but they could be anything).

I am hoping someone can help in providing a VBA macro or formula to complete the following:

The result should give a unique random set of 9 pairs in any order with of course no repeats of pairs.
Eg 1: This result would be correct. 5/10, 20/30, 110/140, 70/ 80, 150/180, 260/270, 40/50, 200/230, 190/220 (A set of 9 unique pairs)

Eg 2: This result would be incorrect. 30/60, 40/50, 40/70 (as both contain 40), 140/170, 5/20, 5/30 (as both contain 5), 100/110, 20/30, 250/280 (Not a set of 9 unique pairs)

The correct formula will be copied over many cells to give a new random set of 9 in each. It is quite possible some *new sets of 9* in different cells would repeat and that is ok.

Here are the 58 pairs.
5/10, 5/20, 5/30, 10/20, 10/40, 20/30, 20/50, 30/60, 40/50, 40/70, 50/60, 50/80, 60/90, 70/80, 70/100, 80/90, 80/110, 90/120, 100/110, 100/130, 110/120, 110/140, 120/150, 130/140, 130/160, 140/150, 140/170, 150/180, 160/170, 160/190, 170/180, 170/200, 180/210, 190/200, 190/220, 200/210, 200/230, 210/240, 220/230, 220/250, 230/240, 230/260, 240/270, 250/260, 250/280, 260/270, 260/290, 270/300, 280/290, 280/310, 290/300, 290/320, 300/330, 310/320, 310/340, 320/330, 320/350, 330/360

Thanks to anybody who helps.

MaxTrax

 

[Peter_SSs]

This has become too complex for me to comprehend, & in my mind too complex for a free public forum like this. I wish you well but I don't see that I will be able to contribute further.

 

[MarcelBeug]

FYI: another thread was started to have the results sorted: http://www.mrexcel.com/forum/excel-questions/942440-sort-groups-4-numbers.html
I provided a formula solution.

 

[Peter_SSs]

FYI: another thread was started to have the results sorted: http://www.mrexcel.com/forum/excel-questions/942440-sort-groups-4-numbers.html
I provided a formula solution.

Thanks Marcel. I had seen that thread & it is partly why I think it's time for me to withdraw.