Randomizer

[CarolynWeaver]

I have been asked by my work to create a Lunch Buddy Program. I wil
need to enter employee names into a list and then have a randomize
select two people at a time until all names have been selected. Ha
anyone ever done this in Excel? If yes, could you explain how I woul
do this.
thank

 

[Bruce Sinclair]

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.