+ Reply to Thread
Results 1 to 6 of 6

duplicate result

  1. #1
    Registered User
    Join Date
    04-14-2016
    Location
    us
    MS-Off Ver
    2007
    Posts
    6

    duplicate result

    hello everyone, i need a few favor/ guide how to solve thisDUPLICATE SCORE.xlsx DUPLICATE SCORE.zip

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,463

    Re: duplicate result

    It might be possible to do this with formulas only, but I don't know how. Would you consider a VBA solution?

    You said "with tie breaker" but you show a place to put 3 names. Do you want to list all names with a tying high score, or just one name after a tie-breaker is applied? What is your tie-breaker algorithm?

    "what if i change other highscore number, can the name also change?" What is the "other" highscore number? What name would you want to change?
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Valued Forum Contributor
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    892

    Re: duplicate result

    For your case, you can use formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    7,505

    Re: duplicate result

    Try this ARRAY formula in C15,
    =IFERROR(INDEX($A$2:$A$9,SMALL(IF($B$2:$G$9=LARGE($B$2:$G$9,1),ROW($B$2:$G$9),""),ROW($A1))-ROW($B$2)+1),"")
    Then drag down.
    ARRAY formula should be confirmed with Ctrl+Shift+Enter Keys together.

  5. #5
    Registered User
    Join Date
    04-14-2016
    Location
    us
    MS-Off Ver
    2007
    Posts
    6

    Re: duplicate result

    YESS YESS .... TQ every body for support, u all save my Headache hahaha tq tq tq, problem solve hahahaha im sooo happy, tq all

  6. #6
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,463

    Re: duplicate result

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

    If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon below their name.

+ 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] Display 1 result for each Duplicate
    By Chantal4130 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2015, 04:03 PM
  2. Replies: 7
    Last Post: 05-08-2015, 01:52 PM
  3. HELP! vBa code for duplicate result
    By wedzmer in forum Excel General
    Replies: 2
    Last Post: 07-09-2014, 01:43 AM
  4. [SOLVED] Vlook up to find Minimum value and maximum value if value has duplicate result
    By ryan4646 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-08-2014, 09:46 PM
  5. delete duplicate with 2 conditions (date and result)
    By owlowl2005 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-03-2014, 09:27 AM
  6. [SOLVED] Vlookup in Duplicate Result Value
    By abhinavbinkar in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-25-2013, 07:51 AM
  7. Duplicate Post > Cell shows formula instead of result
    By sandeephg in forum Excel General
    Replies: 1
    Last Post: 09-27-2007, 01:33 AM

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