Getting a set of random selection from a range

[gifariz]

Hi. Suppose I have a column range of 10 cells. I would like to get 8 of them uniquely and randomly. How do I do that (without macro)? Thanks.

 

[Cubist]

Here's one way.

Book1
	A	B	C	D
1	Sample space	Rand	Rank	Random Samples
2	A	0.10444893	9	I
3	B	0.55059578	5	E
4	C	0.34705898	7	G
5	D	0.44318122	6	F
6	E	0.66369111	4	D
7	F	0.92574379	2	B
8	G	0.93095886	1	A
9	H	0.09251188	10	J
10	I	0.85828199	3
11	J	0.21078037	8
Sheet4

Cell Formulas
Range	Formula
B2:B11	B2	=RANDARRAY(10)
D2:D9	D2	=INDEX($A$2:$A$11,C2)
C2:C11	C2	=RANK(B2,$B$2#)
Dynamic array formulas.

 

[gifariz]

Here's one way.

Book1
	A	B	C	D
1	Sample space	Rand	Rank	Random Samples
2	A	0.10444893	9	I
3	B	0.55059578	5	E
4	C	0.34705898	7	G
5	D	0.44318122	6	F
6	E	0.66369111	4	D
7	F	0.92574379	2	B
8	G	0.93095886	1	A
9	H	0.09251188	10	J
10	I	0.85828199	3
11	J	0.21078037	8
Sheet4

Cell Formulas
Range	Formula
B2:B11	B2	=RANDARRAY(10)
D2:D9	D2	=INDEX($A$2:$A$11,C2)
C2:C11	C2	=RANK(B2,$B$2#)
Dynamic array formulas.

Great! Thank you

 

[Fluff]

Another option without helper cells

=TAKE(SORTBY(A2:A11,RANDARRAY(ROWS(A2:A11))),8)