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

This was a fun one due to the way the data is organized. I put everything into excel tables since they are easier to manage (formulas copy down automatically).

I made the assumption that all pairings are unique: players play each other only once. I also noticed that the matchings happen on consecutive rows. So I used the row to determine the matchings =IF(MOD(ROW(),2)=0,[@Players]&":"&B3,[@Players]&":"&B1) in the Bools_Table. This formula is in the column called composite.

First sort the table by Result greatest to smallest.

Once the table is sorted this way then =IF(OR(G3=G2,G3=G4),G3,"") determines if a result is a duplicate of the one above or below it. This is shown in the tie column.

I calculate a composite pairing like I did for the other table and then use this value to find the score for that pairing in the score column.

Then sort the table by result (highest to lowest) and score (highest to lowest).

hi dflak, this will help me, now i need convert in VBA, I realy need use vba for this.

If someone can vert my problem in VBA solution, i apreciated.

thanks