Hi guys, I am trying to figure out the best formula to use for my scoring excel sheet. For instance, if teams get the same score, the next criteria that will determine who's in the higher placement in the tournament will be where they place in their game.
18 hrs, 6 downloads, no answer. So probably the criteria are not clearly described.
For me it's not obvious what do you mean by "who's in the higher placement in the tournament" which is probably needed, as team1 and team2 have excatly the same values in all columns
Best Regards,
Kaper
So this is for Fortnite. When they place in 1st place, that's the highest placement in their match. I made up those values in all columns because I want it so there are no duplicates. So there shouldn't be any teams with the same ranking. You are more than welcome to change the numbers if you'd like since these numbers are just experimental.
Try in M7:
and copy down. Format it with 0 decimal digits to restore the visible values, but now you can use column M for ranking.Formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks