Using your posted example, this regular formula returns the name of the person with the highest score (if a tie, then TIE is displayed)
Copy that formula into the subsequent merged cells.![]()
G1:G2 =IF(F1=F2,"TIE",INDEX(A1:A2,MATCH(MAX(F1:F2),F1:F2,0)))
Is that something you can work with?
Bookmarks