making a program rotate and delete

[jadensap]

I am so stuck. i am trying to make a wresting program in excel. Th
top row is weight the first colum is the names of each wrestlers coach
Each coach gets to pick up to 5 wrestlers that they do NOT want t
fight theirs . and the wrestlers names get putunder their weigh
class. B]I need the program to rotate each weight class so it wil
randomly match up wrestlers but NOT the ones that don't want to fight.
Am i explaing this well, (i doubt it) [/B]
thanks

 

[jadensap]

I still can't figure it out anyone have any ideas

 

[Balazs - ExcelForums.com]

I can almost make out what you're after

But if there's any way you can clarify your idea even more, I'm sur
someone can come up with a 30 second solution

Thank
Balaz