I have 6 people in my group.
4 people need to meet once a week for 20 weeks.
I need to mix the attendees somewhat evenly over the 20 weeks.
Can a rookie do this in Excel?
I have 6 people in my group.
4 people need to meet once a week for 20 weeks.
I need to mix the attendees somewhat evenly over the 20 weeks.
Can a rookie do this in Excel?
1, 2, 3, 4
2, 3, 4, 5
3, 4, 5, 6
4, 5, 6, 1
5, 6, 1, 2
...
Entia non sunt multiplicanda sine necessitate
As close as you can get it
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks