random values

[RAMatgreenleaf]

i have a list of names which i would like to disply randomly throughout column a
or somehow

i want to be able to come up with differnt lists each being random listing the names of people, like i said randomly

thank you in advance
ryan

 

[Aladin Akyurek]

i have a list of names which i would like to disply randomly throughout column a
or somehow

i want to be able to come up with differnt lists each being random listing the names of people, like i said randomly

thank you in advance
ryan

Book8
	A	B	C	D	E
1
2	Name List	Rand	Rank		Randomized Name List
3	Bob	0.840793	2		Damon
4	Olga	0.824201	3		Bob
5	Damon	0.91247	1		Olga
6	Brian	0.452153	4		Brian
7	Jon	0.328438	5		Jon
8
9
Sheet1

B3, copied down:

=RAND()

C3, copied down:

=RANK(B3,$B$3:$B$7)

E3, copied down:

=IF(ROW()-ROW($E$3)+1<=ROWS($A$3:$A$7),INDEX($A$3:$A$7,MATCH(ROW()-ROW($E$3)+1,$C$3:$C$7,0)),"")