| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Team Role Rotation (number of team members is variable)
In our company we have team meetings in each workgroup, and have a team role
rotation for those meetings. The number of members on each team is different. What I'm trying to do is build a formula that looks at the list of members, determines the length of the member list (counta) and then builds a rotation list. The rotation list is just the list of members repeated say five times over in the same sequence. I'll use that list to populate a matrix. Would like to do this with worksheet functions if possible. Any suggestions would be helpful. Thanks in advance! Scott Example: member list John Doe Bill Smith Susie Brown Jack White Example: rotation list John Doe Bill Smith Susie Brown Jack White John Doe Bill Smith Susie Brown Jack White John Doe Bill Smith Susie Brown Jack White |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set a macro to print variable number of pages in excel? | Excel Discussion (Misc queries) | |||
| sort list of players by team from player list on separate sheet | Excel Worksheet Functions | |||
| How do I assign a text value to a variable number of rows? | Excel Worksheet Functions | |||
| Chart based on variable number of columns | Charts and Charting in Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
