Hi, I have 20 ppl that i need to put in 4 groups with 5 each:
First time Group 1: 1,2,3,4,5 Group 2: 6,7,8,9,10 Group 3: 11,12,13,14,15 Group 4: 16,17,18,19,20 The next week i want to form 4 new groups. However aiming to have as few ppl working together with ppl that they were in group with previously. And the following week same issue. New groups, as few repeats as possible. I have been able to do a lookup-matrix that can tell me how will i am doing with the ambition of no repeats. However, as i am not doing very well, i was wondering if it was possible to do an automatic allocation of ppl based on the few simple rules above? Is it? br Thomas -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts