Create Table
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
"ganga" wrote:
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
|