LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 40
Default determining best data using 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Determining the data type. satadru Excel Discussion (Misc queries) 6 September 8th 08 08:39 AM
Determining the text mode from a variety of data types matt3542 Excel Worksheet Functions 17 July 31st 08 08:01 PM
Determining the current row and col k483 Excel Discussion (Misc queries) 2 November 25th 05 05:50 PM
need help with determining a formula Cal Excel Worksheet Functions 2 November 11th 05 01:49 PM
The match and lookup functions can find literal data but not the same data referenced from a cell Jeff Melvaine Excel Discussion (Misc queries) 3 April 30th 05 01:29 PM


All times are GMT +1. The time now is 04:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"