Hi, In case you are using Excel 2007 or can use Analysis ToolPac you can use =randbetween (lower_limit, upper_limit) with 1 as lower and 5 as upper limit. Otherwise you can use =int(rand( )*100) to generate random integers then divide the numbers by 2, 3, 4, 5, and 6 and select people based on the result, like if prime no select or if even no select.
Hope that helps, Regards, Anand On Nov 14, 11:26 pm, Beanbag <wolkely...@gmail.com> wrote: > 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