+ Reply to Thread
Results 1 to 4 of 4

Large,Index, Match with duplicates

  1. #1
    Forum Contributor
    Join Date
    06-28-2004
    MS-Off Ver
    Home/Office 2016
    Posts
    246

    Large,Index, Match with duplicates

    I am looking for the largest TOTAL SCORE in each division, but need to display 3 placings. Current error: If the score is a duplicate, it is repeating that score with the same rider.
    ALSO - I need to add the 'PLUSES' as part of the tiebreaker (i.e. 940 with 24 pluses would be 1st, 940 with 4 pluses, 2nd...etc)

    * I've attached a spreadsheet that hopefully has more clarification

    Thanks!
    Attached Files Attached Files
    Last edited by x65140; 02-10-2014 at 10:26 AM.

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Large,Index, Match with duplicates

    LARGE-PROBLEM(1).xlsx

    W30
    =INDEX($B$11:$B$56,SMALL(IF($T$11:$T$56=X30,IF($U$11:$U$56=Y30,IF($C$11:$C$56=Z30,ROW($U$11:$U$56)-ROW($A$11)+1))),COUNTIFS($X$30:X30,X30,$Y$30:Y30,Y30)))
    Y30
    =LARGE($U$11:$U$56*($C$11:$C$56=$Z30)*($T$11:$T$56=X30),COUNTIF($X$30:X30,X30))

    Both arrays.
    Copy/drag accordingly
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Forum Contributor
    Join Date
    06-28-2004
    MS-Off Ver
    Home/Office 2016
    Posts
    246

    Re: Large,Index, Match with duplicates

    AWESOME! Appreciate the quick response!!

  4. #4
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Large,Index, Match with duplicates

    You are welcome.
    Thanks for reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Problem Using LARGE formula with Index/Match to pull values when there are Duplicates
    By BDavis in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-11-2014, 02:23 PM
  2. Match/Large with Duplicates (I want to include the duplicates)
    By Willie68 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-13-2013, 01:10 PM
  3. Top 5 values using LARGE and INDEX avoiding duplicates
    By carl916 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-25-2012, 10:41 AM
  4. Replies: 2
    Last Post: 03-16-2012, 12:03 PM
  5. INDEX, MATCH and LARGE
    By ridebikes in forum Excel General
    Replies: 1
    Last Post: 10-24-2011, 04:03 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