A common method uses the Rand function in a column adjacent to your names.
Each time you sort on the Rand column, you will get a randomized list. You
can have formulas in your "specific cells" to this sortable list.

--

Damon Longworth

2007 East Coast Excel / Access User Conference
April 18-20, 2007 - Providing Microsoft Excel training and Microsoft Excel
Classes
Atlantic City, New Jersey
www.ExcelUserConference.com/ECEUC.html

"OdAwG" wrote in message
...
Another Question,

How can I randomize a list of names from a range and then put them in
specific cells,
eample:

1 2 3 4 5
A John
B Jane
C Joe
D Mark
E Robert
F Roy
G Bob
H Jason
I
J Randomize the above list
K and put the results in
L specific cells
M Jason
N Mark
O Joe
P Roy
Q Jane
R Robert
S John
T Bob

Any and all help in this matter is greatly appreciated.

Argus


U



"OdAwG" wrote in message
...
Hello All Excel Gurus

I was wondering if anyone could help me out. I am trying to automate a
manual process of running a bowling bracket sheet. I was able to compare
to scores and get the higher score, but, instead of the score, how can I
get the name associated with that score? Listed below is an example of
the bracket sheet with cell D5 and H5 having the formula enumerated.

1 2 3 4 5
A Name Score Name
B -----------------------------------------
C John 212
D =max(c3,e3) ' this will
give me 213, I would like the name
E Jane 213
F
G Hulk 189
H =max(g3,I3) ' this will
give me 200, I would like the name
I Hogan 200

Any and all help in this matter is greatly appreciated.

Argus