Excel String Permutations

neato, your upload is a file format much newer than Excel 2003 your profile shows.

Please update your profile so we know what tools you have available that will work in your version.

If you aren't aware of it you can find version clicking File > Account.

This will work in all versions.

It won't avoid duplicates entirely. It begins to repeat in Week 8.

With the range of Team names assigned a name ... Team_List and the range of Blue/Red/Green assigned the name Projects
this formula applied to B2:G9

Formula:

=INDEX(Team_List,MOD(COLUMNS($B$1:B$1)+(ROWS(B$2:B2)-1)*COUNTA(Projects)-1,COUNTA(Team_List))+1)

The only way I found to mix up the weekly assignments required multiple self diminishing Data Validation lists and drop downs specific to each week. ie it would require some manual input. However the drop downs would not allow duplication of Teams in any given week.

If that is what you prefer please let me know. Explaining it will be a bit detailed.

I we were to add (or remove) further projects or teams. Do the ranges just need to be updated?

I have not tested this but I believe it would work with the ranges updated. Try experimenting.

With the addition/removal of projects or teams you might want to consider dynamic named ranges (DNRs). If you are not familiar with them they size themselves automatically to fit the data. It could save trouble shooting headaches that may arise from manually updating the ranges.

BTW thank you for the feedback and added rep.

One more thing:

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.