Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Randomizer
I have been asked by my work to create a Lunch Buddy Program. I will need to enter employee names into a list and then have a randomizer select two people at a time until all names have been selected. Has anyone ever done this in Excel? If yes, could you explain how I would do this.
thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Randomizer
In article , CarolynWeaver wrote:
I have been asked by my work to create a Lunch Buddy Program. I will need to enter employee names into a list and then have a randomizer select two people at a time until all names have been selected. Has anyone ever done this in Excel? If yes, could you explain how I would do this. thanks I think there's a more or less good random number generator built into XL. 1 column of names, a second column of random numbers, sort both columns on the random numbers and take each pair of names in the new order. Repeat next time. Easy. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
randomizer as study aide | Excel Programming | |||
Schedule Randomizer | Excel Worksheet Functions | |||
randomizer | Excel Programming | |||
I'm looking for info on the Excel Randomizer feature | Excel Discussion (Misc queries) |