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