complicated problem I think Excel can handle
 

I have groups of rows with first cell identifying the group and the rest have
values like:
part1 10 8 11
part1 9 4 15
part2 13 14 6
part2 3 15 7

total 23 22 17

I need Excel to select the set of parts that will produce the highest values
when each parts values are added to the corresponding values of the other
parts. As in my example the first part1 and part2 were selected to yield the
total 23 22 17. In reality there will be 6 or more parts with 5 values each
and 50 or more of each part to select from.

complicated problem I think Excel can handle
 

TECHIE
From the little that you described, it looks like you could use the SOLVER
tool in Excel.
See this link to access an excelent run-through of how to use this Excel tool.
http://faculty.fuqua.duke.edu/~peckl...ercisesOak.htm

Hope this helps, let us know if you need clarification or further help.
SongBear

"|techie|" wrote:

I have groups of rows with first cell identifying the group and the rest have
values like:
part1 10 8 11
part1 9 4 15
part2 13 14 6
part2 3 15 7

total 23 22 17

I need Excel to select the set of parts that will produce the highest values
when each parts values are added to the corresponding values of the other
parts. As in my example the first part1 and part2 were selected to yield the
total 23 22 17. In reality there will be 6 or more parts with 5 values each
and 50 or more of each part to select from.

complicated problem I think Excel can handle
 

Try Pivot Table:
http://www.freefilehosting.net/download/3c844