Match 2 random unique arrays & then give ANY other (x) numbers

[Lapper]

Thanks to LordLoki for this. At post#4
http://www.excelforum.com/excel-prog...s-numbers.html


I’m now asking:
Question1… If the code can be tweaked to use two (2) sets of unique random numbers instead of, as it is now, one (1) unique random array and one (1) random array?

Question2… If possible, and this only really applies with lower match requests, give ANY of the other numbers in ascending order. Note here that the code does now sort the other numbers in ascending order but it always gives the others starting at the lowest then the next lowest then the next and so on.

minnumber = 0
maxnumber = 20
Samplesize = 6
matched = 0

So for Q2 an Example: Match 6 numbers (Samplesize) in 1 unique random array of 21 (0 to 20) numbers to the same 6 in the other unique random array of 21 numbers. If matched, then give ANY 6 of the other 15 numbers in ascending order.



Please see attached file ‘Sheets 1&2’ for examples.