Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
here is my problem and i'm not sure which functions will get me the answer
that i need! # of persons: 20 Each person can have 1 item from each Category: Category 1 Atk Def Item 1 30 30 Item 2 39 14 Category 2 Atk Def Item 1 15 43 Item 2 8 56 Category 3 Atk Def Item 1 25 42 Item 2 55 26 So I need to know a way to calculate the best possible combination, it could be different amounts of both Item 1 and Item 2 in each category or all of Item 1 in one category, all Item 2 in another category etc. How would I calculate this please? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Determining the data type. | Excel Discussion (Misc queries) | |||
Determining the text mode from a variety of data types | Excel Worksheet Functions | |||
Determining the current row and col | Excel Discussion (Misc queries) | |||
need help with determining a formula | Excel Worksheet Functions | |||
The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) |