Create Table

[Guest]

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

 

[Guest]

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]

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..