Randomizing an array within an index/match

[jason73503]

Greetings,

I'm attempting to randomize both teams and persons within that team to selected roles for debates. There are 5 teams of 9. 2 teams should be randomly selected and the persons of that team should fill random roles.

I figure the best way to do that is to do Randbetween(1,6) for the teams, and then Index/Match for association. But, is there a way to randomize how they are placed within a column using Index/Match from a row (where teams are assigned)?

I've provided a workbook to show my work-in-progress. I'm at a complete loss on how to achieve this. Is there a function, of should I use VBA?

Thanks for any support you may provide.

[AliGW]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Please continue in your original thread here: http://www.excelforum.com/excel-gene...dex-match.html