Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
Complicated Problem | Excel Worksheet Functions | |||
Complicated Problem! | Excel Worksheet Functions | |||
Complicated Vlookup/count problem | Excel Worksheet Functions | |||
Fill handle problem XP | Excel Discussion (Misc queries) |