Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best Fit Solution
Are you trying to assign the players or do you just want the number of
tables for each size group. -- Regards, Tom Ogilvy "GB" wrote in message ... I'm trying to create a computation to best fit tournament seating for a game. For example: If I have 50 players and want a maximum table of 8 players, but don't want a table of 2... the best fit would be 6 tables of 7 players and 1 table of 8 players. The idea is to have the best seating scenario for the entire group based on the variable maximum number. I'm not too familiar with excel but it seems that there would be a pretty easy way to do this. Can anyone help me out with a function or formula that would get this done. Thanks, GB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for a solution | Excel Worksheet Functions | |||
Web Solution | Excel Discussion (Misc queries) | |||
Need a pop up solution! | Excel Discussion (Misc queries) | |||
Solution please | Excel Discussion (Misc queries) | |||
Is there a solution? | Excel Programming |