Hey Damon,
So, your saying then fro the example below the following:
1 2 3 4 5
A John =rand() 'This gives me a
decimal value
B Jane =rand() 'This gives me a
decimal value
C Joe =rand() 'This gives me a
decimal value
D Mark =rand() 'This gives me a
decimal value
E Robert =rand() 'This gives me a
decimal value
F Roy =rand() 'This gives me a
decimal value
G Bob =rand() 'This gives me a
decimal value
H Jason =rand() 'This gives me a
decimal value
I
J 'How do I associate the values from RAND() to the names so that
K 'I can assign them to a specific cell listed below
L
M Jason
N Mark
O Joe
P Roy
Q Jane
R Robert
S John
T Bob
Thanks for the help
"Damon Longworth" wrote in message
...
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