Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Randomizer

6 views
Skip to first unread message

CarolynWeaver

unread,
May 15, 2013, 3:11:59 PM5/15/13
to

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




--
CarolynWeaver

Bruce Sinclair

unread,
May 15, 2013, 6:57:53 PM5/15/13
to
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. :)

0 new messages