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

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