I need a formula than can balance input data automatically. Ive been working on this for quite sometime but unfortunately I cannot seem to crack the secret. Let say for exampe I have 5 Teams, Team A has 4 members, Team B has 5 members, Team C has 6 members, Team D has 7 members and Team E has 9 members. Now what I need is to add this 5 Teams together and divide it into two groups of teams without dividing the members in each team. so basically I will have the result of Team E grouping with Team C , Team E has 9 members plus Team C has 6 members so that would be a total of 15 members, The other group of teams would be Team A, Team B and Team D adding their members, 4 plus 5 plus 7 would be a total of 16 members. So basically this is were i need to get. A formula that can automaticaly sort out the best possible combination of teams for each group. For anyone that can help me, Thanks!
-- ---------------------------------------------------------------------------------- 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
