Results 1 to 3 of 3

direct confrontation tiebreaker

Threaded View

  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    direct confrontation tiebreaker

    Hi.

    I need find a solution to separete equals points each Player, but i need follow a "rule".

    I have Two sheets (Find_Dup, Bolls_Table).
    Firsth, I need find duplicate values in sheet(Find_Dup), coparing values in column B.
    Secondth, I need check in sheet(Bolls_Table), who wins who, check if has same ID_Game (column C), and value in column D.
    then go back to sheet(Find_Dup), write in column C a code that I can use to sort data after.

    See my file, i try show result manualy on sheet(Find_Dup) in column C.

    Exemple:
    This players have same points >>sheet(Find_Dup)
    Names-Result
    Darci Gaucho-26
    Marcos Rodrigo-26
    ---------------------------------------------
    But when their play against each othe, who win?
    >>sheet(Bolls_Table)
    Round-Players-ID_Game-Result
    Round 3-Marcos Rodrigo-2017071518-1
    Round 3-Darci Gaucho-2017071518-2
    Look for same ID_Game(2017071518), then Darci won, becouse 2>1
    Attached Files Attached Files
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] League Table Tiebreaker
    By ScabbyDog in forum Excel General
    Replies: 1
    Last Post: 06-19-2016, 04:44 AM
  2. [SOLVED] Tiebreaker for the Rank function?
    By shanewignall in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-06-2014, 03:22 PM
  3. [SOLVED] Ranking within a group but also with Tiebreaker
    By ncurran217 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-16-2014, 06:30 PM
  4. Replies: 2
    Last Post: 09-19-2013, 09:06 AM
  5. [SOLVED] Index/Rank Problem, based on criteria, if match then tiebreaker
    By brotherwo in forum Excel General
    Replies: 4
    Last Post: 08-29-2012, 10:14 AM
  6. Indoor Soccer League Table Tiebreaker Help
    By JakeD in forum Excel General
    Replies: 10
    Last Post: 10-20-2011, 02:34 PM
  7. high scores and tiebreaker
    By odha in forum Excel General
    Replies: 3
    Last Post: 10-01-2009, 01:17 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