random values

RAMatgreenleaf

Board Regular
Joined
Sep 23, 2005
Messages
84
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
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
RAMatgreenleaf said:
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
ABCDE
1
2Name ListRandRankRandomized Name List
3Bob0.8407932Damon
4Olga0.8242013Bob
5Damon0.912471Olga
6Brian0.4521534Brian
7Jon0.3284385Jon
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)),"")
 

Watch MrExcel Video

Forum statistics

Threads
1,118,018
Messages
5,569,646
Members
412,285
Latest member
Daibear
Top