+ Reply to Thread
Results 1 to 2 of 2

Compare Mins and Maxes of sets of Data

  1. #1
    Registered User
    Join Date
    09-13-2012
    Location
    Atlanta, Georgia
    MS-Off Ver
    Excel 2010
    Posts
    32

    Compare Mins and Maxes of sets of Data

    Hello,

    I need to write a function that returns a data set's name by comparing two parameters of the data set. I am trying to rank the data sets in an order from "Highest" to "Lowest".

    The ranking is primarily done with the first parameter of the data set from highest to lowest (i.e., 10 over 8). The second condition only comes into play if the data sets have the same value for parameter 1. If this is the case, the "Highest" data set is the one with lowest parameter 2 value (i.e., data set <10,0> is ranked before data set <10,1>).

    Any assistance with this would be appreciated. I would like to develop 3 functions, one for determining the highest, 2nd highest and lowest data sets. I've attached an example file if the text is confusing.
    Attached Files Attached Files

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Compare Mins and Maxes of sets of Data

    For highest use..
    =INDEX(B3:F3,MATCH(MIN(IF(MAX(B4:F4)=B4:F4,B5:F5)),B5:F5,0))

    For lowest use..
    =INDEX(B3:F3,MATCH(MAX(IF(MIN(B4:F4)=B4:F4,B5:F5)),B5:F5,0))

    Confirm with Ctrl+Shift+Enter and not just Enter
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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