Hi,

You can use the Solver tool to solve this type of problem. First you need
to attach the add-in under Tools, Add-ins. To learn how to use the tool
Microsoft Excel includes a workbook, Solvsamp.xls in the Office\Samples
folder.

This is probably more than you wanted but...
--
Cheers,
Shane Devenshire


"GeorgiaEddie" wrote:

Guys, who can help me here? I've been heading up a golf outing for
about 12 years now, and not often (but occasionally) I get that golfer
that says,"how'd you make up these groups (in a drunken slur)?". Well,
that's the reason I am looking for some assistance. What I have this
year is six groups of four. The initial groupings I will initiate based
on..., but we will play two more rounds and I would like to maximize
mixing players up the second and third round. There may be a year or so
that I have five groups of four or four groups of four. Will the format
(program) be the same? You'd make my life easier. Are you up for the
'challenge'? Thanks in advance, GE.