Hi, both options seem quite close to what I want. The outcome of Fluff13 is indeed desired. However, game duration was not accurate to the range I'll be working with, that range will be times between 10 and 60 minutes. What I did to adjust his file is =VALUE(B2&60-MINUTE(C2)&60-SECOND(C2)) so as to approach it the same way; make the team with the lowest amount of minutes translate to the highest in the helper column. Now it works exactly as intended. Apology accepted by the way. Attached is the end result. It also taught me the index command. Thanks a lot!
h6zuF7l.png
Bookmarks