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