Random Team Generator allowing Duplicates on separate teams

Hello: I am working a rodeo benefit that allows people to enter up to 2 times for an event. I need to have all of the members randomly assigned to teams of 4 without pairing them with themselves since they can be on 2 teams. I will have all names in Column A, and the number of teams will be dependent on the number of entries (not set amount).

Cross Post:
http://www.mrexcel.com/forum/excel-q...ate-teams.html