Put random numbers in column D using the RAND() function and array enter the
following formula into the cells in which you want return the names. For
example, to return the name into range A21:A25, select those cells, type in
the formula, and press CTRL+SHIFT+ENTER. rather than just ENTER. This MUST
be entered into the result cells as an array formula.

Change the $D$1:$D$5 reference and the $E$1:$E$5 reference to refer to the
correct ranges. The "1:5" should be the number of elements to return.

=INDEX($E$1:$E$5,MATCH(LARGE($D$1:$D$5,ROW(INDIREC T("1:5"))),$D$1:$D$5,0),1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"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