Howdy!

I am trying to develop an excel spread sheet to help in a 6 pack of beer gift exchange. The total amount of participants are currently unknown but I am guessing 60 people. Each person will bring a 6 pack of beer and exchange their beer with 6 other people. At the end, each person will have 6 different bottles of beer.

Is there a way to enter a column of participants names and have 6 coinciding columns that generate other peoples name? Constraints will be each person's name has to be picked 6 times and no one person draws their own name.


Cheers!