Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Table
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Table
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.. "pinmaster" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
CREATE.TABLE | Excel Discussion (Misc queries) | |||
Create new excel table with filtered records from another table | Excel Worksheet Functions | |||
create pivot table from excel table | Excel Worksheet Functions | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |