Create Table

G

ganga

I would like to create a schedule using list of names.i want to divide names
into 2 days... but randomly...and not the same name again.

Names:
a
b
c
d
e
f

Sat Sun
b a
e d

sat
c
f

Thank you
 
P

pinmaster

rHi,

Here's one way:
Start by creating a 2 column table, fill the first column with the formula
=RAND(), fill the second column with the names. Now you can use something
like this to create you schedule:
Sat:
=VLOOKUP(SMALL($A$3:$A$8,1),$A$3:$B$8,2,0)
=VLOOKUP(SMALL($A$3:$A$8,2),$A$3:$B$8,2,0)
=VLOOKUP(SMALL($A$3:$A$8,3),$A$3:$B$8,2,0)
Sun:
=VLOOKUP(SMALL($A$3:$A$8,4),$A$3:$B$8,2,0)
=VLOOKUP(SMALL($A$3:$A$8,5),$A$3:$B$8,2,0)
=VLOOKUP(SMALL($A$3:$A$8,6),$A$3:$B$8,2,0)

to get a new schedule just hit the F9 key.

HTH
Jean-Guy
 
G

ganga

thnak you.. it worked but when i changed one name from the schedule and press
enter the all schedule is changed... i don' tknow how to fix that problem..
 
Top