Give random unique set of numbers [4 quads plus 1 pair]

[MaxTrax]

Hi Guys,

I require a UDF for this if possible.
I have 1574 sets of numbers. Each set is made up of ‘4 quads plus 1 pair’.
E.g. Result: 5/10/20/30, 40/50/70/80, 110/120/140/150, 290/300/320/330, 350|360

The result should give a unique random set of ‘4 quads plus 1 pair’ in any order with of course no repeats of sets.

If this can be modified, then that would be great.
http://www.mrexcel.com/forum/excel-questions/936216-give-random-unique-set-9-pairs.html#post4500928

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

Here are the 1574 sets
https://www.dropbox.com/s/k3desreoq5f8r40/1574 Sets.xlsx?dl=0

Thanks

MaxTrax

 

[MaxTrax]

Correction to above (#1)

E.g. Result: 5/10/20/30, 40/50/70/80, 110/120/140/150, 290/300/320/330, 350|360

Should read E.g. Result:
5/10/20/30, 40/50/70/80, 100/110/130/140, 290/300/320/330, 350/360 (not 350|360)


And 1574 sets are here:
https://www.dropbox.com/s/k3desreoq5f8r40/1574 Sets.xlsx?dl=0

MaxTrax

 

[MaxTrax]

Another correction.....Sorry!

The result should give a unique random set of ‘4 quads plus 1 pair’ in any order with of course no repeats of sets.

Of course I already have 1574 unique sets......doh

So all I want is an improved formula, if possible, (than below) or UDF to select one of these sets in a cell. The result is in D1.

I'm already using

=VLOOKUP(C1,Sets,2)

in D1

Where 'Sets' is a defined name of the 1574 sets (A1 to B1574) and C1 is a random number between 1 and 1574.

I hope this now make sense. Apologies again.

[TABLE="class: grid, width: 600"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD="align: center"]1[/TD]
[TD]Name 'Sets' (A1:B1574)[/TD]
[TD]Random No 1 to1574[/TD]
[TD]Result here[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD="align: center"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD="align: center"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD="align: center"]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD="align: center"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD="align: center"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD="align: center"]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD="align: center"]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]and so on to A1574:B1574[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1574[/TD]
[TD]1574[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


MaxTrax