Set Teams and Random Pairing of names.

Each person gets to pick teammate

team Name Name
1 luanne, bridget
2 clay, trudi
3 niki, jodi
4 george, lenard
5 trudi
6 trudi
7 bridget
8 clay
9 clay
10 niki
11 niki
12 jodi
13 george
14 lenard
15 lenard

But they also have to draw some of their teammates. So if there is not a teammate in column =c. I need the spreadsheet to give the person a teammate but the teams cannot be the same pairs as the ones that they picked. All teams must be unique. It needs to suffle the line up or sort the teams order. And if george goes 1st then he can't go again for right away. He should have someone go between the next runs so his horse can rest. I hope this is clear and I really appreciate the help!! Thanks