Results 1 to 10 of 10

finding optimal set of data with 2 nonvariable values

Threaded View

  1. #1
    Registered User
    Join Date
    12-16-2014
    Location
    RO
    MS-Off Ver
    2007
    Posts
    5

    finding optimal set of data with 2 nonvariable values

    hi,

    I need to find the optimal solution for the set. the conditions are info 1 minimum AND info 2 maximum value. I have many more than 6 sets.

    Each set has 2 values as you can see. for each set i have 6 values resulted from analyses. I need to find the set that has the best results on the analyses.

    For each set i think i'll do an average for info 1 and info 2 and than find the best set. But i don't know how to find the set.

    i attached an excel file with a sample of data.

    for example set 1 is formed by 3,416 and 4,25 as info 1 and info 2 and so on.
    i need to find which of the sets is best in terms of low value for info 1 and high value for info 2


    Thank you very much
    Attached Files Attached Files
    Last edited by ghiras; 12-16-2014 at 08:11 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 10-20-2013, 07:16 PM
  2. input box problem, cell filtering problem, result display while locking sheet
    By croozin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2013, 08:52 AM
  3. Replies: 6
    Last Post: 05-28-2013, 05:08 PM
  4. Replies: 2
    Last Post: 01-22-2013, 07:09 AM
  5. [SOLVED] Started out as an Access problem. Now an Excel problem
    By RobertM in forum Excel General
    Replies: 2
    Last Post: 04-26-2006, 02:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1