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 |
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 |
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 |
All times are GMT +1. The time now is 12:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com