Get Combination Of Unique Values From N Columns Using Rand Or RandBetween Function

Quote:

---

Originally Posted by papabill

The only thing that came through was a page (SHEET 2) of numbers, with "=RAND()" as the ONLY formula in each cell. Sorry, but nothing about it makes sense.

---

You should look more closely.

Yes, RANK is a better solution, so you could change the formulae in my offering:
C17:
=INDEX(A$3:A$12,RANK(M3,M$3:M$12))

D17:
=INDEX(C$3:C$12,RANK(N3,N$3:N$12))

E17:
=INDEX(E$3:E$12,RANK(O3,O$3:O$12))

F17:
=INDEX(G$3:G$12,RANK(P3,P$3:P$12))

then copy them down to fill 10 rows; much simpler than my:
=INDEX($A$3:$A$12,MATCH(LARGE(M$3:M$12,ROW()-ROW($C$16)),M$3:M$12,0))